| Disappearing Days [message #672324] |
Thu, 11 October 2018 08:00  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
Had a search and can't see any other references, but if there are, please point me at 'em.
So, we know that the dates 1582-10-05 to 1582-10-14 are treated as the date 1582-10-15 (due to Julian-Gregorian switchover, those dates don't actually exist - weird, but hey there it is)
I have never had problems with this, until now. We recently switched to using SQL Developer 18.2 from our old, trusty SQL Developer 3.1
If I execute
select to_date('1582-10-04', 'yyyy-mm-dd') from dual;
However
If I execute that same query in version 18.2 (pointing at the same database, same schema etc. etc.) I get
24-SEP-1582
So, it appears that v18.2's date formatting isn't handling the missing days correctly.
Can anyone replicate this in their 18.2 SQL dev (i.e. make sure it's not just my install) and also has anyone had to handle this before? If so, how did you approach it?
TIA
[Updated on: Thu, 11 October 2018 09:43] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
