Hi Scott:
>
> Craig is right: you can get the 12 hour format with a simple SET command, and you can get rid of the seconds with SET SECONDS.
Do these settings influence on the character string (time) which returns by adir() function, do you know? Or I still need to convert this string in the right format?
I had written the UDF a)before we had the DATETIME() function :) and b)to get rid of the leading "0" in the time.
If it's not broken, fix it until it is.
My Blog