(RADIATOR) RE: Oracle to_date with integer-date's Date format

[Anheuser, Frederik {POYN~Kaiseraugst}]

Hi,

my solution was, to define the Oracle SQL statement for entering the accounting data 
myself (Radiator manual section 6.26.13). I do not use "AcctColumnDef". Thus, I could 
include the "to_date" function call properly quoted. My configuration:

AcctSQLStatement insert into ACCOUNTING (TIMESTAMP, ...) values (to_date('%i %g %f 
%j:%k:%p','DD MM YYYY HH24:MI:SS'), ...)

The advantage: it works. The disadvantage: it gives one big, ugly statement which 
contains the definitions of all accounting columns.

Regards,

Frederik Anheuser
--
Frederik Anheuser              e-Mail: [EMAIL PROTECTED]
F. Hoffmann-La Roche AG         Phone: +41 61 68-84104
POYN-A, Room 224/123              Fax: +41 61 68-83004
CH-4070 Basel, Switzerland        URL: http://informatics.roche.com/remacc


> -----Original Message-----
> From: cistron [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 8:03 AM
> To:   [EMAIL PROTECTED]
> Cc:   [EMAIL PROTECTED]
> Subject:      Oracle to_date with integer-date's Date format
> 
> On 17th October in reply to frederik querry that how to convert integer
> date to oracle date format, Mike McCauley had mentioned that he should
> formatted date as mentioned in Radiators manual.
> 
> AcctColumnDef SDATE,Timestamp, formatted-date,to_date('%e %m %Y
> %H:%M:%S',DD MM YYYY HH24:MI:SS').
> 
> When we use it radiusd service is terminated.
> 
> Kindly help.
> 
> Regards.

===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.