calculate Days Between [message #403863] |
Tue, 19 May 2009 04:57 |
avrillavinge
Messages: 98 Registered: July 2007
|
Member |
|
|
i have two dates
start date and end date
i need to find days between start date and end date
pls help
date format is char yyyymmdd
|
|
|
|
|
|
|
|
|
|
|
Re: calculate Days Between [message #403901 is a reply to message #403890] |
Tue, 19 May 2009 08:27 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Reread pablolee's answer.
If you needed to use TRIM, you either described your situation wrongly or you made an error in your solution.
Are your two dates really varchar2? Or are they of datatype DATE after all?
|
|
|