Hello,
On Jul 3, 1:21pm, postmaster wrote:
> Subject: (RADIATOR) formatted-date for TIME_STAMP doesn't work
>
> Greetings,
>
> Is the following syntax for 'formatted-date' parameter for TIMESTAMP
> correct:
>
> AcctColumnDef TIME_STAMP,Timestamp,formatted-date,to_date ('%e %m %Y
> %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
The to_date function is an Oracle function. If you really want to insert the
date as a string, you could use:
AcctColumnDef TIME_STAMP,Timestamp,formatted-date,'%e %m %Y %H:%M:%S'
which will make an insert clause something like:
insert into ACCOUNTING
(......., TIME_STAMP)
values
(......, ' 5 07 1999 09:05:29')
but you would be better off defining your TIME_STAMP columns as either an
integer or a datetime, because mysql wont do date arithmetic on char columns by
default.
Hope that helps.
Cheers.
>
>
> Note: It's all in one line.
>
> But, The accounting doesn't recognize it(error) and doesn't log. But the
> integer-date works:
>
> AcctColumnDef TIME_STAMP,Timestamp,integer-date
>
> I have the perl Date Format modules installed on my system and
> have the TIME_STAMP defined as char[30] in the ACCOUNTING table in the
> mSQL database.
>
> Any suggestions ?
>
> thanks,
> [EMAIL PROTECTED]
>
>
>
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from postmaster
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
