Re: Dates and different time zones
| From: | Richard Lynch | Date: | Tue, 10 Apr 2007 22:20:34 +0000 |
| Subject: | Re: Dates and different time zones | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-252488@lists.php.net to get a copy of this message | ||
On Tue, April 10, 2007 11:38 am, Satyam wrote:
> In PHP dates are stored as seconds from an arbitrary zero set at Jan
> 1st,
> 1970, so does MySql with date/time values though it shows them
> formatted but
nitpick:
I don't think MySQL uses Unix timestamp internally, as it's quite
capable of storing a wider range than Unix timestamp.
I could be wrong, of course, depending on what data type you were
thinking of, and what version of MySQL, and what server settings are
in effect...
Databases have a bewildering plethora of date/time storage options. :-)
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?