SOS eventTime apparently not working

[Kralidis,Tom [Burlington]]

> The following long URL should not return any hits since there 
> is no record in our db that falls between the eventTime range 
> I specify as part of the URL.
> 
> http://sos-web.tamu.edu/sos-cgi/madis?service=sos&request=GetO
> bservation&ver
> sion=0.1.2&offering=ndbc_44029&responseFormat=text/xml;%20subt
> ype=om/0.14.7&
> observedProperty=http://marinemetadata.org/cf%23air_pressure_a
> t_sea_level&ev
> entTime=<gml:TimePeriod><gml:beginPosition>1990-01-01</gml:beg
> inPosition><gm
> l:endPosition>1990-02-01</gml:endPosition></gml:TimePeriod>
> 
> There is always only 1 row that should be returned -- the 
> most recent observation.  As of right now, the time is 
> <time>2007-07-12 07:04:00-05</time> which isn't anywhere near 
> the TimePeriods defined in the query URL.
> 
> Am I doing something wrong -- that is likely!
> 
>       "sos_timeitem"             "m_date"
>       "sos_offering_timeextent"  "20070530T1800Z"
>
> It appears that I'm registering the time column properly 
> since it does show up in the XML.
> 
> MapServer version 4.99

What does your underlying data connection look like?  Any chance you can
wrap up a test case (.map file and small sample data?)

..Tom