Please help with Informix date and time

[jsgoober]

If I have a field/column, transtime datetime year to minute,
how do I go about SELECTING/RETRIEVING records/rows
that have the transtime older than CURRENT - minutes?

Thanks

 

[PHV]

Try something like this:

SELECT * FROM YourTableName
 WHERE transtime < CURRENT - 30 UNITS MINUTE

Hope This Help
PH.