(RADIATOR) Date Format in <AuthBy SQL>

[Separovic, Jason]

I've tried many different combinations but I can't get the date into the
database in the following 

<AuthBy SQL>
.....
   FailureQuery insert into auth(date,user) values('%Y-%m-%d %H:%M:%S',
'%U')
</....


I need the date to be in the format YYYY-MM-DD HH:MM:SS

I tried entering the date into a char() field and nothing was entered.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.