[EMAIL PROTECTED] writes: > So datediff('month', '2008-02-01 23:59:59','2008-01-31 00:00:00') should > return 1 even though the difference is really only 1 second? Seems > goofy to me.... >
well, this is one second rounded up to the next full month...If that is the kind of information you want to compute, it's probably not that goofy after all. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------