> Hi, all: > > 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 > > . . . and sos_timeitem is 't' when I do NOT tack on an > eventTime constraint. > > But when I try to tack on an eventTime constraint to the URL, > I get an emty result set (and I know there should be obs). > > eventTime=<gml:TimePeriod><gml:beginPosition>2007-08-01<gml:be > ginPosition><g > ml:endPosition>2007-08-03</gml:endPosition></gml:TimePeriod> > > If the DATA string were this, instead . . . > > select * from v_platform_sensor_obs > > . . . and the sos_timeitem were 'm_date', I'd get hits w/ the > above eventTime constraint. > > All I'm really trying to do is control the ouputted format of > my timestamp col., and something must be getting lost in translation. >
Charlton, 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? ..Tom
