>>
>>transf(ttoc(datetime(), 1), '@R ####-##-##T##:##:##')
>>
>>
>>But the best is using parameters - no conversion needed
>
>Thank you for the link. For this particular case I chose to use GetDate() that seems to be the native SQL server function and probably synchronizes the date and time with the SQL Server which I think is a benefit.
GetDate() will give you the current datetime on the server. ttoc(datetime()) will give you datetime on the client.
If it's not broken, fix it until it is.
My Blog 
