OK Got that. Thanks, Om
On Tue, Jun 26, 2018 at 3:38 PM, Lukas Eder <[email protected]> wrote: > Yes, use plain SQL templating as I mentioned in the previous message: > https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating > > > Am Di., 26. Juni 2018 um 12:05 Uhr schrieb Omprakash Verma < > [email protected]>: > >> Thank you for your reply. Can you please guide me how to change datetime >> in localtimezone while fetching the records from the postgres. >> >> selectStep = selectStep.select(fieldName).as(aliasName)) >> >> >> Is there any way to create sql query like "Select id, created_at at time >> zone 'pst' from account >> >> Thanks, >> Om >> >> On Tue, Jun 26, 2018 at 3:12 PM, Lukas Eder <[email protected]> wrote: >> >>> Hello, >>> Thanks for your message. As you've noticed also on your cross-posted >>> Stack Overflow question... >>> https://stackoverflow.com/q/51028351/521799 >>> >>> ... this syntax is not yet supported out of the box by jOOQ. The >>> relevant feature request is: >>> https://github.com/jOOQ/jOOQ/issues/7238 >>> >>> You can always work around missing functionality by using plain SQL >>> templating: >>> https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating >>> >>> I hope this helps, >>> Lukas >>> >>> Am Di., 26. Juni 2018 um 07:54 Uhr schrieb <[email protected]>: >>> >>>> Getting some issues with org.jooq api. Saving data into DB, in UTC >>>> format for timestamptz fields. When fetching the same from db, there is a >>>> way in postgres. >>>> >>>> select id, created_datetime at time zone 'pst' from account. >>>> >>>> Is there any way to achieve the same into jooq ? >>>> >>>> >>>> selectStep = selectStep.select(fieldName).as(aliasName)) >>>> >>>> -- >>>> 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 a topic in the >>> Google Groups "jOOQ User Group" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>> topic/jooq-user/1PGtTt8JRTE/unsubscribe. >>> To unsubscribe from this group and all its topics, 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 a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/jooq-user/1PGtTt8JRTE/unsubscribe. > To unsubscribe from this group and all its topics, 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.
