[EMAIL PROTECTED] wrote:
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....
I have been staring at this until I'm getting goofy.
Written as it is, isn't the time interval 1 second short of two days?
If you want an interval of 1 second shouldn't it be
datediff('month', '2008-02-01 00:00:00','2008-01-31 23:59:59')
?
Gerry, more confused than usual (as usual)
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
