I don't think soTIME is the fractional part of the day. Zero represents 12:00 AM, .25 is 6:00 AM, .5
is 12:00, .75 is 3:00, and so on.

greetings, clem
I don't think soTIME is the fractional part of the day. Zero represents 12:00 AM, .25 is 6:00 AM, .5
is 12:00, .75 is 3:00, and so on.
What would you suggest as the description? If I continue to quote the next 2 paragraphs, I find:I don't think so
And this is true. So why isn't:For example, March 1, 1900 12:00:00 PM is represented by the floating value 61.5
and March 1, 1900 12:00:00 AM is 61.0.
If you omit a part of an input Date/Time value, SQLWindows supplies the default of
0, which converts to December 30, 1899 (date part) 12:00:00 AM (time part).
true? (It can help to clarify a claim like this, Clem. If there's a doc bug here that needs fixing and/or clarifying, it helps to get your underlying thought about this. Thanks.)TIME is the fractional part of the day. Zero represents 12:00 AM, .25 is 6:00 AM, .5
is 12:00, .75 is 3:00, and so on.
Not trueJeff Luther wrote:true? (It can help to clarify a claim like this, Clem. If there's a doc bug here that needs fixing and/or clarifying, it helps to get your underlying thought about this. Thanks.)TIME is the fractional part of the day. Zero represents 12:00 AM, .25 is 6:00 AM, .5 is 12:00, .75 is 3:00, and so on.
Users browsing this forum: [Ccbot] and 0 guests