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 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.
