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

[Hugh Irvine]

Hi Mikey -

For some reason I thought the Timestamp was in UTC, but it isn't is it?

How can Richard do what he wants to do?

cheers

Hugh


On 7 Mar 2005, at 14:31, Rickard Ekeroth wrote:

>
> 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.
>
>

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.