[mapserver-users] date format in a template (after a GetFeatureInfo call)...
Hi, I've got a GetFeatureInfo which return a date (in my template). Since we don't control the sql statement behind the GetFeatureInfo, is there a way to format the date in the template? my layer retreive the data from Oracle Spatial and I received the date in this form: 19-NOV-09 which is Oracle default format for date... MartinOuellet ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] date format in a template (after a GetFeatureInfocall)...
Hi, How about making an Oracle view for publishing data through Mapserver and selecting date as TO_CHAR and control the format that way? -Jukka Rahkonen- Martin Ouellet wrote: Hi, I've got a GetFeatureInfo which return a date (in my template). Since we don't control the sql statement behind the GetFeatureInfo, is there a way to format the date in the template? my layer retreive the data from Oracle Spatial and I received the date in this form: 19-NOV-09 which is Oracle default format for date... MartinOuellet ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] date format in a template (after a GetFeatureInfo call)...
It might not be what you're looking for, but you can define your layer as geom from (select a, b, c, to_char(the_date, 'format') from osTable) using... Josh Martin Ouellet wrote: Hi, I've got a GetFeatureInfo which return a date (in my template). Since we don't control the sql statement behind the GetFeatureInfo, is there a way to format the date in the template? my layer retreive the data from Oracle Spatial and I received the date in this form: 19-NOV-09 which is Oracle default format for date... MartinOuellet ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.425 / Virus Database: 270.14.78/2521 - Release Date: 11/23/09 07:52:00 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] date format?
Hi David, a belated thank you for this tip - I didn't think of trying to do it in the select statement. For the record here is the syntax I used: SELECT DATE_FORMAT(My_DATE_FieldName,'%W %M %D, %Y') ... etc. produces a nice date like: Monday September 20th, 2004 thanks again, Sacha On Wed, Jul 30, 2008 at 1:13 PM, Fawcett, David [EMAIL PROTECTED] wrote: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sacha Black Sent: Wednesday, July 30, 2008 3:07 PM To: mapserver-users@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_date19690101/ms:Discovery_date whereas we would want 1969-01-01 Best regards, Bart ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
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_date19690101/ms:Discovery_date whereas we would want 1969-01-01 Best regards, Bart ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] date format?
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_date19690101/ms:Discovery_date whereas we would want 1969-01-01 Best regards, Bart ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users