Re: [RADIATOR] reference manual - date stamps
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-boun...@open.com.au [mailto:radiator-boun...@open.com.au] On
> Behalf Of Martin Edge
> Sent: Friday, 23 July 2010 1:04 PM
> To: radiator@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 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 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
>
>
>
> 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: .. i...@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@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.
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] reference manual - date stamps
Actually, %d, is the right one, it seems.
Thanks
Martin.
From: radiator-boun...@open.com.au [mailto:radiator-boun...@open.com.au] On
Behalf Of Martin Edge
Sent: Friday, 23 July 2010 1:04 PM
To: radiator@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 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 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
[cid:image001.jpg@01CB2A68.9FB70C10]
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<http://www.emersion.com.au/>
General Enquiries: .. i...@emersion.com.au<mailto:i...@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@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
[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 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 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
[cid:image001.jpg@01CB2A67.87FE9E40]
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
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@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
