[mapserver-users] date format?

[Fawcett, David]

Have you tried using a date format function in your SQL statement?  
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func
tion_date-format

David.

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Sacha
Black
Sent: Wednesday, July 30, 2008 3:07 PM
To: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] date format?


I've got point data in a MySQL database that I am displaying in my map.
I'd like to label the points with a date, but the date format stored in
the database looks like this:

"2008-06-17 00:00:00"

and we would like to put a label on the map in some kind of more user
friendly format (and omitting the time portion which we do not need)....
is this kind of re-formatting for labels possible in Mapserver? Prefer
not to create a new field in the DB as there are thousands of records...

any ideas?

sacha


Fri May 9 09:53:29 EDT 2008

Hi list,

using a shapefile with a Date column, is it possible to change the date
format (string) that Mapserver will use in the WFS GetFeature output?

Now it outputs:

<ms:Discovery_date>19690101</ms:Discovery_date>

whereas we would want 1969-01-01

Best regards,
Bart
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users