Marco Belladelli (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480...
) *commented* on HHH-16442 (
https://hibernate.atlassian.net/browse/HHH-16442?atlOrigin=eyJpIjoiM2I5MD...
)
Re: trunc() function with offset datetimes on Oracle (
https://hibernate.atlassian.net/browse/HHH-16442?atlOrigin=eyJpIjoiM2I5MD...
)
This looks like a limitation of Oracle’s native TRUNC(date) function, the relative docs (
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TRUNC... )
state:
The value returned is always of data type DATE , even if you specify a
different datetime data type for date
causing loss of the timezone information.
I’m not sure but how we might be able to get around this, maybe always emulating and using
to_timestamp_tz instead of to_date (which has the same problem)?
(
https://hibernate.atlassian.net/browse/HHH-16442#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-16442#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:916089c )