Hi Mark, thank you for this suggestion, but this parameter doesn't change the behaviour. In case the documentation at https://docs.oracle.com/en/database/oracle/oracle-database/23/jjdbc/accessing-and-manipulating-Oracle-data.html does apply in this situation, J2EE13Compliant would only change behaviour for columns already defined as TIMESTAMP.
Regards Daniel -----Original Message----- From: mark <mc.pr...@gmail.com> Sent: Sonntag, 21. April 2024 22:15 To: geoserver-users@lists.sourceforge.net Subject: [EXTERN!]: Re: [Geoserver-users] Wrong time values for Oracle DATE columns Op 18-04-2024 om 11:39 schreef Calliess Daniel Ing.: > Hi, > > I just discovered that GeoServer is rounding Oracle DATE attribute > values down to zero or twelve hours when I'm publishing data from a > 'Oracle NG (OCI)' data store. Examples: > > 1.1.2024 17:34:12 becomes 1.1.2024 12:00:00 or > > 1.1.2024 03:17:05 becomes 1.1.2024 00:00:00 > You might want to look into and experiment with the "oracle.jdbc.J2EE13Compliant" connection option of the Oracle JDBC driver _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users