Hi Vijay,
By default, jOOQ maps Oracle's DATE column to java.sql.Date and TIMESTAMP
to java.sql.Timestamp.
If you want to use Oracle's historic DATE semantics (date-time with seconds
precision), then you can have jOOQ generate java.sql.Timestamp columns also
for DATE columns using the <dateAsTimestamp/> code generation flag:
<!-- Generate java.sql.Timestamp fields for DATE columns. This is
particularly useful for Oracle databases.
Defaults to false -->
<dateAsTimestamp>false</dateAsTimestamp>
Details here:
http://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/
For the reference, I'll also post this as an answer to your Stack Overflow
question:
http://stackoverflow.com/q/23560232/521799
Cheers
Lukas
2014-05-09 12:04 GMT+02:00 <[email protected]>:
> My database is Oracle 11g. I have a table with a column of type DATE.
> While i select the rows from this table the date fields has date but with
> no time. What do I do to retrieve the date with time.
>
> thanks
> --Vijay
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
