Denver Braughler wrote:
>
> 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.
but the point here is that he wants to compare a date with (a value
that has another amount of time added to it):
DateTimeField < ValueDate + '23:59:59'
and in my case, I am suggesting the TIMESTAMPADD() function to add
together ValueDate + '23:59:59'
>
> > 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". :)
slip of the cut and paste button, but point take !
>
> Here is a link with no line break as transmitted:
> <http://platinum.intersys.com/csp/docbook/DocBook.UI.Page.cls?
> KEY=RSQL_timestampadd>.
but in my ng reader, i STILL get the line break :- {
>
> > consider the use of extrinsic functions to do the calculation
> > within COS.
> Mainly, he needs to learn to deal with $H format dates.
>
don't disagree
> (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.)
--
kev
