>Why VFP return the wrong hour when i use hour(datetime()) ?
>As i know , if i use hour(datetime()) to get the system time, the time format will in 24 hour !!!
>But that is an error when the system time is 12PM !!!
>It return 12 to me when i try to get the hour , actually the return value must be 24 !!!
>I don't know whne wrong with that ????
>Can anyone help me ?? Tell me what happen ???
>I need it to display the time in my project !!!!
RTFH. The HOUR() function ignores the setting of SET HOUR, and would return 0 at midnight, or 12 at noon. There is no time 24:00, there is a time 00:00; the range of times is 00:00 (midnight) - 23:59 (I left off seconds). Try the following:
tDateTimeTest = {^1999-01-01 24:00:00)
tDateTimeTest = {^1999-01-01 00:00:00}
? HOUR(tDateTimeTest)