(RADIATOR) Timestamp Formatting

[Shon Stephens]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hugh, 
     Thanks for the tip. I guess I could keep it as the epoch.
Really, I just want to have a time format that can be understood by
my operators. I will probably just use perl or php to convert the
timestamp after it has been selected from the database. Also, this is
the format I insert the timestamp into the database in all the other
tables. Consistency and all.

Shon Stephens
sstephens at corp.goamerica.net

- ----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "Shon Stephens" <sstephens at corp.goamerica.net>; "Radiator Mailing
List" <radiator at open.com.au>
Sent: Friday, May 11, 2001 7:33 PM
Subject: Re: (RADIATOR) Timestamp Formatting


> 
> Hello Shon -
> 
> The Timestamp used inside Radiator is a numeric value representing
> the number  of seconds since the UNIX epoch (midnight January 1,
> 1970) and is used for  calculations that expect this to be the
> case.
> 
> You can add an additional field to the RADPOOL table if you wish
> and provide  your own queries which will write a formatted string
> in addition to the  standard Radiator fields.
> 
> Just out of interest, why do you want to do this?
> 
> regards
> 
> Hugh
> 
> 
> On Saturday 12 May 2001 02:52, Shon Stephens wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > I am planning on using <AddressAllocator SQL>. In the RADPOOL
> > table there is a TIME_STAMP field. Is this the time that the
> > address was allocated? Can I use DateFormat to format this? If so
> > how? If not, what can I do?
> >
> > Thanks,
> > Shon Stephens
> > shon at goamerica.net
> >
> > P.S. My PGP Public Key is available from either
> > ldap://europe.keys.pgp.com or http://pgpkeys.mit.edu . You can
> > download it and sign it if you like.
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: PGPfreeware 7.0.3 for non-commercial use
> > <http://www.pgp.com> 
> >
> > iQA/AwUBOvwYwUwGLkuD4lDdEQKc0ACg8jAv9KjhxF6c4o0F3y9lh9h5XkcAoK+Z
> > Bnx0wP9aTid4nkK35PnscdZV
> > =3eWc
> > -----END PGP SIGNATURE-----
> >
> > ===
> > 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.
> 
> -- 
> 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. ===
> 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.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOv0lbUwGLkuD4lDdEQJxKgCeMWbvBPquL3c5GV2f9qP04/SVsdEAoI5k
xuIucXQxPDh7c6pEPwXJDvJh
=yg67
-----END PGP SIGNATURE-----

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