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.