DateTime Field Calculation

[gkrenton]

Have a table that has a field modify_date in modify_date DATETIME YEAR TO SECONd format I want to use this field in a when statement comparing it to today less 2 days In access I can do a modify_date<=date()-2 & get the proper result but seems informix is a bit more picky.
What is the syntax for doing this comparision realizing that the 'time' element will never be exact.
- Thanks

Gina

 

[PHV]

Something like this ?
modify_date<=TODAY-2 UNITS DAY

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gkrenton]

PH -
You've saved me yet again, that does work. I have more specific Informix SQL books on the road so maybe I'll be able to find some of this syntax stuff w/o always asking.

Thanks a ton.

- gina