SOS eventTime not liking formatted time cols
Charlton Galvarino
cplist at SECONDCREEK.ORG
Mon Nov 26 11:26:26 PST 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