Not really that goofy, just very specific.
The SQL Server manual describes it this way:
"Returns the number of date and time boundaries crossed between two
specified dates."
Regards,
Noah Hart
-----Original Message-----
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....
--
D. Richard Hipp <[EMAIL PROTECTED]>
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
