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

[Hugh Irvine]

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.