[Geoserver-users] TimeStamp with milliseconds

GeoServer GeoServer User
1

Hi,

I created a sql table with a datetime column and had geoserver point to it.

When I manually save the milliseconds on a feature I can't seem to get it to
log into the sql server.

I added the following value to the datetime column

2015-12-26T12:12:12.700z

In the sql server it always saves 2015-12-26T12:12:12.000. I can see the
post xml that it actually post that value to geoserver, but I end up with
sql not having that exact value.

Any help appreciated.

Regards,

Michael

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/TimeStamp-with-milliseconds-tp5218652.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

If I add a timestamp data type to my sql table, in Geoserver the datatype
displays it as byte. Does that mean timestamp isn't supported in
Geoserver

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/TimeStamp-with-milliseconds-tp5218652p5218653.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

3

I believe GeoServer should handle timestamps:
http://osgeo-org.1560.x6.nabble.com/GeoServer-converting-TimeStamp-from-UTM-to-local-time-td3790658.html
and
http://www.azavea.com/blogs/labs/2012/02/geoserver-timestamp-styling-and-postgresql-datetime-fields/

Although that's using PostGIS, but I'd guess it should support timestamps for other databases too in that case.
Cheers,
Jonathan

-----Original Message-----
From: michael6779 [mailto:michael.tang@anonymised.com]
Sent: Wednesday, August 05, 2015 4:59 PM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] TimeStamp with milliseconds

If I add a timestamp data type to my sql table, in Geoserver the datatype displays it as byte. Does that mean timestamp isn't supported in Geoserver

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/TimeStamp-with-milliseconds-tp5218652p5218653.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This message has been scanned for viruses by MailControl - www.mailcontrol.com

Click https://www.mailcontrol.com/sr/Gxk2vuexjErGX2PQPOmvUkWM85sEKD4+mCgfYESQdZS7qLKjkTlWIhPksOG1WMeUThJl+GNKLvWU8yB5sLY89Q== to report this email as spam.

________________________________

HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.
If you have received this message in error please advise us immediately and destroy all copies of it.

HR Wallingford Limited
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 02562099

________________________________

4

On Thu, 6 Aug, 2015 at 12:51 PM, Jonathan Moules J.Moules@anonymised.com wrote:

I believe GeoServer should handle timestamps: http://osgeo-org.1560.x6.nabble.com/GeoServer-converting-TimeStamp-from-UTM-to-local-time-td3790658.html and http://www.azavea.com/blogs/labs/2012/02/geoserver-timestamp-styling-and-postgresql-datetime-fields/ Although that’s using PostGIS, but I’d guess it should support timestamps for other databases too in that case.

Actually I’ve just checked the code and for PostGIS we (the GeoTools team) translate a timestamp into a Postgresql Timestamp while for MSSqlServer we only handle Time and Date.

Feel free to file an enhancement request but I don’t have access to a windows machine to develop against so I don’t know who would be able to deal with it.

Ian

5

Thanks for getting back to me

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/TimeStamp-with-milliseconds-tp5218652p5218808.html
Sent from the GeoServer - User mailing list archive at Nabble.com.