Nadya...
SET SECONDS seems to have no impact on ADIR(). Since the date and time are returned as a Date and Character string (respectively), you'd probably have some formatting to do...
Scott
>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.
Scott D. Grabo
Chief Information Officer
Occupational Health Group
First Advantage Corporation