[mapserver-dev] Issue with WFS requests to SQL server with datetime columns

Martin Icking martin.icking at bentley.com
Tue Jan 23 07:00:05 PST 2018


No, we don't need a new process parameter for the layer. YYYY-MM-DD hh:mm:ss
is already one of the formats accepted by mapserver. The easy way to fix the
problem is, just add a new datetime format parameter (e.g. 120) in the
CONVERT() function.

You can test it with SQL Server. Open the Microsoft SQL Server Management
Studio and run the following commands:

SELECT Convert(varchar, GETDATE());
Result:
Jan 23 2018  9:25AM

SELECT Convert(varchar, GETDATE(), 120);
Result:
2018-01-23 09:25:00

The output of the second command is recognized by map server.




--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-Dev-f4252683.html


More information about the mapserver-dev mailing list