Hi Lukas,

I'd like to store all timestamps in Oracle in UTC but the app that
receives data from a client should accept timestamps with an offset.

What would be the most appropriate pipeline with JOOQ to ensure that
only UTC is being used internally:

Client -> "2013-06-14T06:32:33.830+05:00" -> ZonedDateTime z; ->
Timestamp.from(z.toInstant()) -> JOOQ DSL -> Database

?

Or is it better to remap the Oracle TIMESTAMP type to a different type
for the generated code, such as Instant or LocalDateTime?

Are there any examples in the documentation where this is covered?

Cheers,

Ben

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

Reply via email to