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>


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

Original text of this message