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
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
