Sysdate minus a timestamp column? 1

[Ant0]

I can't work out how to return a whole number from

select sysdate-stamp from foo;

where stamp is a timstamp column with a default value of sysdate. All I want ot do is minus the two and capture all rows where the difference is 1.

 

[SantaMufasa]

Ant,

"1" what? 1 Year, 1 Month, 1 Day, 1 Hour, 1 Minute, 1 Second, 1/10 Second, 1/100 Second, 1 millisecond? We can offer code as soon as we know what "1" means.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Ant0]

Sorry, 1 day.

 

[SantaMufasa]

Ant,

Here are some data:

SQL> select stamp from foo;

STAMP
----------------------------
18-MAY-05 09.31.13.542000 AM
13-DEC-03 12.56.44.000000 AM

Here are whole-number differences between the current date/time and the dates:

col a heading "Days|Diff" format 999
select trunc(sysdate-cast(stamp as date)) a from foo;

Days
Diff
----
0
522

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Ant0]

Perfect, thank you.