Hello Martin -
There are two different tables, for different purposes.
See sections 5.2 and 5.3 in the Radiator 4.6 reference manual ("doc/ref.pdf").
regards
Hugh
On 23 Jul 2010, at 13:11, Martin Edge wrote:
> Actually, %d, is the right one, it seems.
>
> Thanks
> Martin.
>
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Martin Edge
> Sent: Friday, 23 July 2010 1:04 PM
> To: [email protected]
> Subject: [RADIATOR] reference manual - date stamps
>
> Hey Guys,
>
> Correct me if I’m wrong, but in the reference material, in multiple locations
> (for instance page 110) an example is given on how to insert into oracle.
>
> It says:
> AcctColumnDefTIME_STAMP,Timestamp,formatted-date,to_date\
> (’%e %m %Y %H:%M:%S’, ’DD MM YYYY HH24:MI:SS’)
> This will result in a an insert statement something like this:
> insert into ACCOUNTING(TIME_STAMP, ......) values
> (to_date(’16 02 1999 16:40:02’, ’DD MM YYYY HH24:MI:SS’), ....)
>
>
> According to further down in the manual %e is actually the two digits of the
> year. %i is the day of the month.
>
> %i The Timestamp day of the month (2 digits)
>
> Thanks
> Martin.
>
>
> Martin Edge
>
> Software Development, Business Analysis, Product Management and Design
>
> <image001.jpg>
>
> Emersion Software Systems Pty Ltd
> Phone: .......... 1300 793 310
> Fax: .............. 1300 793 320
> Address: ........ L7, 313 LaTrobe Street, Melbourne VIC 3000
> Website: .................... http://www.emersion.com.au
> General Enquiries: ...... [email protected]
>
> This communication may contain CONFIDENTIAL or copyright information of
> Emersion Software Systems Pty Ltd (ABN 28 119 061 791). If you are not an
> intended recipient, you MUST NOT read, print, keep, forward, copy, use, save,
> retransmit or rely on this communication or any attachments, and any such
> action is unauthorised and prohibited. If you have received this
> communication in error, please reply to this e-mail to notify the sender of
> its incorrect delivery, and then delete both it and your reply. Emersion does
> not guarantee the integrity of any emails or any attached files. The views or
> opinions expressed are the author's own and may not reflect the views or
> opinions of Emersion. Thank you.
>
>
> _______________________________________________
> radiator mailing list
> [email protected]
> http://www.open.com.au/mailman/listinfo/radiator
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
