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: 19690101 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
RE: [mapserver-users] date format?
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: 19690101 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?
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: > > 19690101 > > 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 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