SOS eventTime not liking formatted time cols

Charlton Galvarino cplist at SECONDCREEK.ORG
Mon Nov 26 14:26:26 EST 2007


Hi, Tom:

> > I am running into a problem w/ eventTime when I am trying to
> > hit a timstamp col. that I've formatted.  In other words, my
> > SOS would return nice results for this DATA string . . .
> >
> > select *, to_char(m_date at time zone 'UTC','YYYY-MM-DD') ||
> > 'T' || to_char(m_date at time zone 'UTC','HH24:MI+00:00') as
> > t from v_platform_sensor_obs
> 
> What happens when you apply the eventTime constraint with
> gml:beginPosition and gml:endPosition formatted as per the to_char
> functions in your SQL statement?

No dice.

Link w/o eventTime (all results):  http://preview.tinyurl.com/yvzmfe

Link w/ eventTime (no results):  http://preview.tinyurl.com/2ey9sf

TIA,

Charlton



More information about the mapserver-users mailing list