oracle11g - Change Excel date number to Oracle date

Question

I'm having date as 41293 in oracle, how can i show it in DD/MON/YYYY format?

If i copy pasted it in Excel and change it to date format, it shows 01/19/13 Please help me.

Answer 1

The value you have is the number of days since the 30th of December 1899. Try:

select to_char(
  to_date('1899-12-30', 'YYYY-MM-DD') + 41293,
  'DD/MON/YYYY') from dual