Re: [Q] DATE - 1/2 hour ????

Keyoor wrote:
>
> I want to subtract 1/2 an hour from any given date and find the records
> between these 2 dates.

Keyoor,

Since the expression (sysdate - 1) will yield a date that is 24 hours earlier
than now, to get all of the dates in the last 1/2 hour period, try:

      select my_stuff
        from my_table
       where date_col between sysdate and sysdate - 1/48; 

Good luck,

Rob Verlander, TMG Consulting Received on Wed Oct 09 1996 - 00:00:00 CEST