[RADIATOR] AddQuery and TO_DATE function

[rohan.henry @cwjamaica.com]

Can the TO_DATE be used with AddQuery like below?

AddQuery        insert into ACTIVE_SESSIONS \

(USER_NAME,NAS_IP_ADDRESS,NAS_PORT,ACCT_SESSION_ID,ACCT_START_TIME,FRAMED_IP_ADDRESS,
\
                NAS_PORT_TYPE,SERVICE_TYPE) \
                values \

('%U','%{NAS-IP-Address}','%{NAS-Port}','%{Acct-Session-Id}','TO_DATE (%F)',
\
                '%{Framed-IP-Address}','%{NAS-Port-Type}','%{Service-Type}')

My issue is that the %F variable returns "Jan  7, 2014 11:10:51" which
apparently is causing the foll. database error.

"ORA-01858: a non-numeric character was found where a numeric was expected"

Radiator flags the field like below.

<*>'Jan  7, 2014 11:10:51'

A sample date that got written to the column successfully is like below. Is
it possible to use the TO_DATE to get this exact format?

Dec 5, 2013 3:19:24 PM



Rohan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20140107/14b3b809/attachment.html