Re: MySQL base time?

by "Keith D Sellars" <Keith(at)webgraffix.com>

 Date:  Wed, 30 Apr 2003 07:25:04 -0400
 To:  "Rajnish Bhaskar" <r.bhaskar(at)compserv.gla.ac.uk>
 Cc:  <hwg-languages(at)hwg.org>
 References:  localhost
  todo: View Thread, Original
The following statement has confused me a little, taken from the link you
supplied:

Note: The valid range of a timestamp is typically from Fri, 13 Dec 1901
20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that
correspond to the minimum and maximum values for a 32-bit signed integer).
On windows this range is limited from 01-01-1970 to 19-01-2038.

Am I understanding correctly that if my sites are hosted on UNIX servers
(which they are), then the epoch time is Dec 13, 1901 20:24:54 instead of
Jan 1, 1970?


Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"


----- Original Message -----
From: "Rajnish Bhaskar" <r.bhaskar(at)compserv.gla.ac.uk>
To: "Keith D Sellars" <Keith(at)webgraffix.com>; "Keith D Sellars"
<Keith(at)webgraffix.com>
Cc: <hwg-languages(at)hwg.org>
Sent: Wednesday, April 30, 2003 4:19 AM
Subject: Re: MySQL base time?


> Hi Keith,
>
> > OUTSTANDING!  Here is a link I found to do it online:
> > http://javascript.internet.com/equivalents/unix-date-time-converter.ht
> > ml
>
> I don't know if this applies at the moment or not, but since I know
> that you do a lot of work in PHP, take a look at the PHP date
> function: http://www.php.net/manual/en/function.date.php which will
> do the conversion for you.
>
> Raj.
> --
> Rajnish Bhaskar
> r.bhaskar(at)compserv.gla.ac.uk, http://lordofthemoon.com
> IT Education Unit, University of Glasgow
> http://www.iteu.gla.ac.uk/
> --
> We're women.  We have double standards to live up to.
>        -- Ally McBeal
>
>
>
>

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA

This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.