preparing Date Time Year To Second for last 24 hours

Posted in 1998

Sukumar Konduru — Mon, 01 Jun 1998 14:00:28 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi I have a database column "date time year to second" I need to prepare SQL statement to do get the results for last 24 hours. For example If current date and time are 06/02/98 10:25:00 then I need query like this. select * from xxx where start <="1998-06-02 10:25:00" andstart >= "1998-06-01 10:25:00" I want to know in ESQLC or SQL 1. How to find current date and time in "year to second"? 2. How to mainpuate above to get date for exactly for 24hours back ?. Thank you sukumar konduru sukumar@gte.net