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!

The same Excel DATE.VALUE function in SQL

Bridge DBA TeamApr 17 2012 — edited Apr 17 2012
Hi, I need to convert a date in a number that Excel can recognize.

I'm trying to do a

SELECT
(trunc(SYSDATE) - TO_DATE('1900-01-01', 'yyyy-mm-dd'))
FROM dual

And I retrieve this: 41014

But today in excel is 41016!!

Why? There is a better solution than this?

Thank you, R.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2012
Added on Apr 17 2012
#date, #excel, #value
5 comments
2,213 views