Re: TIMESTAMP query

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 30 Aug 2005 01:04:15 -0700
Message-ID: <1125389007.165514@yasure>

June Moore wrote:
> Can you pls tell me how to select where a TIMESTAMP date is N hours
> ago?
>
> select * from <table> where job_date ... ?
>
> thanks
> JM

SQL*Plus: Release 10.1.0.4.0 - Production on Tue Aug 30 01:03:38 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select to_char(systimestamp, 'HH:MI:SS') from dual;

TO_CHAR(

---

01:03:50

SQL> ed
Wrote file afiedt.buf

   1* select to_char(systimestamp-1/24, 'HH:MI:SS') from dual SQL> / TO_CHAR(

---

12:03:59

SQL>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Aug 30 2005 - 03:04:15 CDT