(RADIATOR) UTC Timestamp in SQL String Format...

[Rickard Ekeroth]

Thanks Hugh!

However all the formattings (including %F) yield localtime and not UTC. This
is my problem...

-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]On
Behalf Of Hugh Irvine
Sent: 07 March 2005 14:37
To: rickard at spidernet.net
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) UTC Timestamp in SQL String Format...



Hello Richard -

The Timestamp attribute that is added to radius accounting requests is
in UTC (it is the UNIX time in number of seconds contained in a 32 bit
integer).

There are a number of ways of formatting the Timestamp - for what you
want to do see %F in section 6.2 of the Radiator 3.11 reference manual
("doc/ref.html").

regards

Hugh


On 7 Mar 2005, at 13:09, Rickard Ekeroth wrote:

>
> Hello!
>
> Is there a way to obtain the current timestamp of a packet in
> 'extended SQL
> date time format' but in UTC rather than localtime? The localtime
> causes me
> some headache due to daylight saving time. Also I would really like to
> store
> my timestamp in the database as a 'date time' rather than storing a
> naked
> second count.
>
> However if I have to use the second count, I wonder: How many bits are
> used
> for the 'seconds after 1 jan 1970'-timestamp? Is it a 32 or 64 bit
> integer?
>
> Thank you for your attention and have a nice day!
>
> Regards,
>
> Rickard Ekeroth @ SpiderNet
> Software Developer / Analyst
> rickard at spidernet.net
> +35722844870
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: I am travelling this week, so there may be delays in our
correspondence.

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
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.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.