tag:blogger.com,1999:blog-36470398.post6720560567236422333..comments2023-10-14T10:34:25.304+03:00Comments on Cloud Architecture and Technology Blog: MySQL, Oracle, DB2, PgSQL and Firebird versus Leap Years and Division by Zerocmihaihttp://www.blogger.com/profile/06014247302155057225noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-36470398.post-65784976841552519902008-02-11T12:55:00.000+02:002008-02-11T12:55:00.000+02:00for FirebirdSQL> SELECT 0/0 FROM leaptest; ???it s...for Firebird<BR/>SQL> SELECT 0/0 FROM leaptest; ???<BR/><BR/>it should be:<BR/>SQL> SELECT 0/0 FROM RDB$DATABASE;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-36470398.post-53814911566626856932008-02-09T02:00:00.000+02:002008-02-09T02:00:00.000+02:00Or choose Firebird and you are 100% ok :-)Or choose Firebird and you are 100% ok :-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-36470398.post-39407861290822947192008-02-08T21:09:00.000+02:002008-02-08T21:09:00.000+02:00Well Mihai,What would you expect from piece of cra...Well Mihai,<BR/><BR/>What would you expect from piece of crap dbms?! <BR/>The standard reply from Mysql fanboys is that you should put the database in sql_mode=strict_all_tables. However, in the most enterprise environments you cannot really do this once the application got already built on the default settings.<BR/>The best move you could is to download the latest and greatest PostgreSQL and 99.999% of your problems might go away.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-36470398.post-81335641373761770762008-02-05T16:59:00.000+02:002008-02-05T16:59:00.000+02:00Yes, you are correct, it just spits a warning and ...Yes, you are correct, it just spits a warning and enters 0000-00-00 in case of invalid date formats or invalid dates.cmihaihttps://www.blogger.com/profile/06014247302155057225noreply@blogger.comtag:blogger.com,1999:blog-36470398.post-59255230248106661722008-02-05T16:09:00.000+02:002008-02-05T16:09:00.000+02:00You need to insert using ISO dates, ie '2008-02-28...You need to insert using ISO dates, <BR/>ie '2008-02-28'<BR/><BR/>INSERT INTO leaptest VALUES ('2008-02-28'); works fine<BR/><BR/>I got this valuable information from #mysql on ircAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-36470398.post-80496219205560839952008-02-05T16:04:00.000+02:002008-02-05T16:04:00.000+02:00You need to insert using ISO dates, ie '2008-02-28...You need to insert using ISO dates, ie '2008-02-28'.<BR/><BR/>INSERT INTO leaptest VALUES ('2008-02-28'); works fine<BR/><BR/>I got this valuable information from #mysql on irc.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-36470398.post-26037264785474161272008-02-05T15:45:00.000+02:002008-02-05T15:45:00.000+02:00Very Nice.Very Nice.Anonymousnoreply@blogger.com