days_between>>

[i257156]

Got a sticky problem which is causing me a few problems in Query Builder Oracle...... HELP PLEASE!!!!!
I have a date and I want to know how many days have passed.
I have used the help facility and so far have come up with:
MONTHS_BETWEEN(SEV_ACTUAL_DATE, SYSDATE)
This returns the months between.
Is there such a command as days_between or similar?
Thanks
JB

 

[sem]

Are you joking? Explicit subtraction returns this number!

Regards, Dima

 

[i257156]

No I am not joking... Just becuase it says programmer by my name doesn't mean I know about Oracle.

I have very limited Oracle experience....

Where can I find out about the command "? Explicit subtraction"?

Thanks

 

[sem]

date2-date1 => returns number of days between date1 and date2.

Regards, Dima

 

[i257156]

Didn't realise how easy Oracle was... Am learning more and more each day..

Thanks for the prompt reply.
JB