Home » SQL & PL/SQL » Client Tools » Disappearing Days (11.2.0.4.0 - SQL Developer 18.2.0.183)
Disappearing Days [message #672324] Thu, 11 October 2018 08:00 Go to next message
pablolee
Messages: 2876
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;
in version 3.1 I get what you would expect i.e. a display showing the 4th October 1582
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

Re: Disappearing Days [message #672445 is a reply to message #672324] Mon, 15 October 2018 13:36 Go to previous messageGo to next message
thatjeffsmith
Messages: 78
Registered: July 2009
Location: Raleigh, NC
Member

a bug with dates pre gregorian calendar - fixed in 18.3

Re: Disappearing Days [message #672450 is a reply to message #672445] Mon, 15 October 2018 17:12 Go to previous message
pablolee
Messages: 2876
Registered: May 2007
Location: Scotland
Senior Member
Thanks Jeff. Much appreciated
Previous Topic: SQL*Plus output problem (merged 3)
Next Topic: Password Expired
Goto Forum:
  


Current Time: Sat Oct 20 00:16:04 CDT 2018