SOS eventTime not liking formatted time cols

[Kralidis,Tom [Burlington]]

> 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