That's the expected behaviour - if you need to preserve the time of the date make the column a timestamp (preferably with timezone) rather than a data which only stores the year, month and day.
Ian On Thu, 18 Apr 2024 at 10:56, Calliess Daniel Ing. < daniel.calli...@stadt-salzburg.at> wrote: > 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 > > > > This happens only when I'm publishing a complete table, not when I'm > defining an SQL view. Directly after creating the new layer, the column > type is set to the Java data type 'Date'. Comparing to an SQL view I saw > that there the column is defined as 'Timestamp'. But also changing the data > type using the 'Customize attributes' function to 'Timestamp' or 'Time' > doesn't help. > > > > This happend in GeoServer 2.23.0 and also 2.25.0. > > > > Does anybody have an idea what's going on here. > > > > Thank you and best regards > Daniel > _______________________________________________ > 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 > -- Ian Turton
_______________________________________________ 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