TD-18892: Doc Date/Time: ".75 is 3:00" is wrong

Report bugs and possible workarounds for ANSI TD versions
clemdoc
Austria
Posts: 225
Joined: 08 Mar 2017, 09:51
Location: Austria

TD-18892: Doc Date/Time: ".75 is 3:00" is wrong

Post by clemdoc » 17 Jan 2013, 16:35

dev.pdf, Chapter 7, Date/Time:
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.
I don't think so :)
greetings, clem

Jeff Luther

Re: TD-18892: Doc Date/Time: ".75 is 3:00" is wrong

Post by Jeff Luther » 17 Jan 2013, 20:49

For anyone who needs to know where in dev.pdf, that quote is, it's on pg. 7.4.
I don't think so
What would you suggest as the description? If I continue to quote the next 2 paragraphs, I find:
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).
And this is true. So why isn't:
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.
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.)

clemdoc
Austria
Posts: 225
Joined: 08 Mar 2017, 09:51
Location: Austria

Re: TD-18892: Doc Date/Time: ".75 is 3:00" is wrong

Post by clemdoc » 18 Jan 2013, 16:20

Hi!
Jeff Luther wrote:
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.
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.)
Not true :)
My underlying thought: I would say 0.75 is 18:00 (6:00 PM), not 15:00 (3:00 PM) as 24 x 0.75 = 18. Put in bold tags to clarify.
Have a nice weekend,
clem

Return to “Bug Reports (TD 4.2 and older)”

Who is online

Users browsing this forum: [Ccbot] and 0 guests