Please ignore. I was able to resolve using the individual variable. to_date(’%e %m %Y %H:%M:%S’, ’DD MM YYYY HH24:MI:SS’)
Rohan On Tue, Jan 7, 2014 at 7:34 PM, rohan.henry @cwjamaica.com < rohan.he...@cwjamaica.com> wrote: > 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 radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator