Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date to Date Conversion

999664Feb 20 2015 — edited Feb 20 2015

Hi,

SELECT to_date('20-FEB-2015','DD-MON-YYYY')-to_date(DATE_INFO_UPDATED,'DD-MON-YYYY') 

FROM BO_MASTER where BO_CODE=264288;

I am converting Date_info_Updated to DD-MON-YYYY format while it is already date datatype.

Value of Date_info_Updated := '20-FEB-2015'

So, the expected output should be 0.

But i am getting  output =730487.

Can you explain why?

Thanks in advance,

Phanindra.
This post has been answered by Arun Kumar Gupta on Feb 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2015
Added on Feb 20 2015
#sql
10 comments
2,257 views