Hi Erlend, Thanks for your message. This deprecation was a bit unfortunate, because while it is possible to re-enact similar functionality via data type binding, the current situation is still a bit confusing - and it has confused many others as well.
I'm hoping that jOOQ 3.8 will bring answers to how to best create bindings for various date time data types, including TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ). Also, there should be out-of-the-box bindings for these cases. Until then, it is safe to continue using <dateAsTimestamp/>. "Deprecated" here means that we'll remove the flag in the future, but it is still supported. If you have any additional, specific questions, let me know and I'm very happy to help. I hope this helps (for now), Lukas 2016-02-15 12:22 GMT+01:00 <[email protected]>: > As you now have deprecated the use of dateAsTimestamp, it is not so clear > to me how to achieve the same effect using bindings only. I tried to create > and use a binding (implementing Binding<Date, Timestamp>) similar to your > org.jooq.impl.DateAsTimestampBinding, but this results in loosing the time > component of the Oracle date. So as of now, I'm stuck with using the > dateAsTimestamp flag. > > (This reply (with a small edit) is also posted as a comment to > http://stackoverflow.com/a/23569699/1282989.) > > fredag 9. mai 2014 18.33.17 UTC+2 skrev Lukas Eder følgende: >> >> 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. > -- 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.
