Hi, I ran a few tests on MySQL. One question is how does TIMESTAMPDIFF work with February 29:
select timestampdiff(year, '2000-01-01', '2001-01-01'); -- 1 select timestampdiff(year, '2000-03-01', '2001-03-01'); -- 1 select timestampdiff(day, '2000-03-01', '2001-03-01'); -- 365 select timestampdiff(year, '2000-02-29', '2001-02-28'); -- 0 (hm...) select timestampdiff(day, '2000-02-29', '2001-02-28'); -- 365 select timestampdiff(month, '2000-02-29', '2001-02-28'); -- 11 select timestampadd(year, 1, '2000-02-29'); -- 2001-02-28 I do want to support TIMESTAMPDIFF at some point, but currently I don't have time to implement it myself. Patches are welcome of course! Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
