Skip to Main Content

SQL Developer

BC leap dates yyyy-02-29

User_3ABCESep 22 2022

The Oracle database considers leap date -0004-02-29 valid. SQL Plus shows such dates, but SQL Developer and SQLcl show the next day -0004-03-01 instead.

SQL*Plus> select date '-4-2-29', date'-4-3-1'-1 from dual;

DATE'-4-2-2 DATE'-4-3-1
----------- -----------
-0004-02-29 -0004-02-29

==========================================================

SQLcl> select date '-4-2-29', date'-4-3-1'-1 from dual;

DATE'-4-2-29'    DATE'-4-3-1'-1
________________ _________________
-0004-03-01      -0004-03-01
Comments
Post Details
Added on Sep 22 2022
0 comments
25 views