Hi, 

I've noticed a strange behavior on DateDiff Month, tested with 1.3.166 and 
1.3.176:

SELECT  datediff('MONTH', '2014-04-01', '2015-03-31' ): RESULTS 12
SELECT  datediff('MONTH', '2014-04-01', '2015-03-01' ): RESULTS 11
SELECT  datediff('MONTH', '2014-04-01 04:00:00', '2015-03-01' ): RESULTS 10


Is this not supposed to be based on the boundary cross, and the result be 
allways 11? Did I miss something?

Thanks 

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to