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

[Seth G]

Sounds good. I'd be happy to test any pull request on our setup. 

On Tue, Jan 23, 2018, at 4:00 PM, Martin Icking wrote:
> 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
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-dev