Re: how to specify date 12 hrs b4 sysdate
From: Rod Corderey <Lane_Associates_at_Compuserve.com>
Date: Tue, 15 Jun 1999 13:19:00 +0100
Message-ID: <376644B4.583FF0CE_at_Compuserve.com>
Date: Tue, 15 Jun 1999 13:19:00 +0100
Message-ID: <376644B4.583FF0CE_at_Compuserve.com>
Hi,
as sysdate -1 is sysdate - 1day, then sysdate - 12 hours is sysdate - 0.5.
so for date only columns
where this_date = trunc(sysdate-0.5)
or datetime columns
where this_date = sysdate -0.5
Hope this helps
Rod Corderey
Lane Associates
RodCorderey_at_Lane-Associates.com
http://www.Lane-Associates.com
Lai wrote:
>
> Hi,
>
> I want to extract records whose date is 12 hours before sysdate. How do I
> code in SQL?
Received on Tue Jun 15 1999 - 14:19:00 CEST