tag:blogger.com,1999:blog-27482298.post4060365344554139197..comments2024-02-25T22:29:18.572+00:00Comments on Andrew's Oracle Blog: ORA-01841Unknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-27482298.post-57367621430768000292012-03-09T08:51:35.091+00:002012-03-09T08:51:35.091+00:00what about leap years ?
SQL> select date ...what about leap years ?<br /><br /><i><br />SQL> select date '-4708-02-29' from dual;<br />DATE'-4708-02-29'<br />-------------------<br />4708-02-29_00:00:00<br /><br />SQL> select date '-4712-02-29' from dual;<br />select date '-4712-02-29' from dual<br /> *<br />ERROR at line 1:<br />ORA-01847: day of month must be between 1 and last day of month<br /></i><br /><br />there is more than one discussion about <a href="http://en.wikipedia.org/wiki/0_(year)" rel="nofollow">year 0</a>Laurent Schneiderhttps://www.blogger.com/profile/13833048234373264017noreply@blogger.com