[RADIATOR] AddQuery and TO_DATE function

[rohan.henry @cwjamaica.com]

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.henry at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20140108/6dc5846b/attachment.html