>>Hi,
>>
>>When I Set Hours to 12, datetime() is returning a time as if I had set hours to 24. How can I be sure to get a 12 hours notation?
>>
>>Regards,
>>
>>Koen
>
>Despite what Help file says, it always returns the same value (am/pm) when I use SET HOURS.
But this works:
SET HOURS TO 24
? TTOC(DATETIME())
SET HOURS TO 12
? TTOC(DATETIME())
:o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.