number of days between two dates 2

[latha9]

Hi,

I need to find the number of days between sysdate and database column (this is varchar2 datatype).Can any one help me how to do it.

Thanks,
Latha

 

[lewisp]

Convert your varchar2 to a date, then subtract the greater date from the earlier one.

 

[BJCooperIT]

trunc(sysdate) - to_char(your_date,'MM/DD/YYYY')

In the mask, use whatever format your date needs.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[lewisp]

I think BJCooper deserves more credit than I. Share my star!

 

[BJCooperIT]

Very kind of you lewisp.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus