Re: preparing Date Time Year To Second for last 24 hours

Posted in 1998

ccremid — Mon, 01 Jun 1998 16:31:33 -0400 — source: Informix-list mailing list archive (1991-1998)

Sukumar Konduru wrote: > > Hi > > I have a database column "date time year to second" > [snip] > > I want to know in ESQLC or SQL > 1. How to find current date and time in "year to second"? Try: SELECT * from YourTable where start <= (CURRENT YEAR TO SECOND) and start >= (CURRENT YEAR TO SECOND - 1 UNITS DAY) > 2. How to mainpuate above to get date for exactly for 24hours back ?. > > Thank you > sukumar konduru > sukumar@gte.net Hope This helps Tino