how to specify date 12 hrs b4 sysdate

From: Lai <lyekheng_at_hotmail.com>
Date: Tue, 15 Jun 1999 18:42:40 +0800
Message-ID: <37662dd0.0_at_news.cyberway.com.sg>

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 - 12:42:40 CEST

This message: [ Message body ]
Next message: Rod Corderey: "Re: how to specify date 12 hrs b4 sysdate"
Previous message: Nationwide Personnel Group: "ORACLE TECHNICAL CONSULTANTS"
Next in thread: Rod Corderey: "Re: how to specify date 12 hrs b4 sysdate"
Reply: Rod Corderey: "Re: how to specify date 12 hrs b4 sysdate"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message