Hi Chang,
12 pm is middle of the day while middle night is 0 o'clock.
? hour(ctot("05/23/1999 0:20:20")) && 0 (night)
? hour(ctot("05/23/1999 12:20:20")) && 12 (day)
HTH
Chen
>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 !!!!
>HELP !!!
>
>regard,
>chang
Chen Nan