[RADIATOR] reference manual - date stamps

[Hugh Irvine]

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: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au] On Behalf Of Martin Edge
> Sent: Friday, 23 July 2010 1:04 PM
> To: radiator at open.com.au
> 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: ...... info at emersion.com.au
>  
> 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
> radiator at open.com.au
> 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.