kevin furze wrote: > I think you need to use the DATEADD function or the TIMESTAMPADD > function,
He wants to compare a $H date to an ODBC-format date - not add. > take a look at > http://mesh-master:1972/csp/docbook/DocBook.UI.Page.cls? > KEY=RSQL_timestampadd Sure, as if we all call our servers "mesh-master". :) Here is a link with no line break as transmitted: <http://platinum.intersys.com/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_timestampadd>. > consider the use of extrinsic functions to do the calculation within COS. Mainly, he needs to learn to deal with $H format dates. (Though if time stamps are in $ZTS format and he wants to compare dates based on his current local time zone, I don't know how to do that in SQL.)
