>I have a field datetime type, where is stored the result of datetime function. I need that this function return the hour:minute:seconds:millesimal or centesimal seconds, how can I do it?
>
>Thanks
>Carla Silva
Hi Carla,
I don't know your application need, but SECONDS() returns the seconds elapsed since midnight. Although it's not completely accurate down to the millisecond, it does return the seconds elapsed down to the millisecond. You may be able to use this function to create a workaround for your situation.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.