>Hello all!
>
>I use the time function as a clock, but when its after 12:00, the timer instead of using 1:00 pm 2:00 pm 3:00 pm , it uses 13:00 , 14:00 and 15:00, is there any way to convert them to a regular time value?
>
>Thanks in advance...
>
>Juan :)
From Help:
TIME( ) always returns a value in 24-hour format and isn't affected by SET HOURS. The value returned by DATETIME( ) is determined by the current SET HOURS setting.
SET HOURS TO 12
SET DATE AMERICAN
? RIGHT(TTOC(DATETIME()),11)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.