MVSFORUMS.com

[cappertan]

I am looking for an example to a query to find
ID's where the UPDATE_DT >= CONTACT_DT.
contact_dt is defined as YYYY-MM-DD
up_dt is defined as yyyy-MM-DD HH:MM:SS.
Example:

Select *
from test.mytable
where UPDATE_DT >= CONTACT_DT
and UPDATE_DT >= Today

update date = 2004-09-01 18:00:00
Contact date = 2004-08-31
DO I substring the date in the where clause? Use A Cast function

I looked in the SQL manual but did not see
anything giving me a clue.
Suggestions please.
_________________
Capp

[kolusu]

cappertan,

Try this

[cappertan]

Thanks Kolusu. I will give it a go.
_________________
Capp