Namely the thirteenth of December 1901, 12:45:52, Pacific Time.
All dates later than this passed in format "yyyy-mm-dd hh:mm:ss" to the
strtotime function return the correct unix timestamp value (as can be
verified by passing it back to date()).
If a date earlier than 1901-12-13 12:45:52 is used, it returns an error.
I tried this for a while to find the exact cut-off point, and this is it.
Any reason - possibly a limitation of the integer value that is used? I
didn't find this documented anywhere...
--
Christoph Burschka 3 1636
Christoph Burschka schrieb:
Namely the thirteenth of December 1901, 12:45:52, Pacific Time.
All dates later than this passed in format "yyyy-mm-dd hh:mm:ss" to the
strtotime function return the correct unix timestamp value (as can be
verified by passing it back to date()).
If a date earlier than 1901-12-13 12:45:52 is used, it returns an error.
I tried this for a while to find the exact cut-off point, and this is it.
Any reason - possibly a limitation of the integer value that is used? I
didn't find this documented anywhere...
--
Christoph Burschka
Whoops, I should have checked more closely. In fact this *is* documented
as the minimal value of most dates due to the length of the 32-bit integer.
I never considered that these "Y2K" problems work backwards, too...
--
Christoph Burschka
Christoph Burschka <ch****************@rwth-aachen.dewrote:
>Christoph Burschka schrieb:
>Namely the thirteenth of December 1901, 12:45:52, Pacific Time.
All dates later than this passed in format "yyyy-mm-dd hh:mm:ss" to the strtotime function return the correct unix timestamp value (as can be verified by passing it back to date()).
If a date earlier than 1901-12-13 12:45:52 is used, it returns an error. I tried this for a while to find the exact cut-off point, and this is it.
Any reason - possibly a limitation of the integer value that is used? I didn't find this documented anywhere...
Whoops, I should have checked more closely. In fact this *is* documented as the minimal value of most dates due to the length of the 32-bit integer.
I never considered that these "Y2K" problems work backwards, too...
The upper end of this range is coming up as well, in the middle of
February, 2038.
--
Tim Roberts, ti**@probo.com
Providenza & Boekelheide, Inc.
Tim Roberts wrote:
Christoph Burschka <ch****************@rwth-aachen.dewrote:
>Christoph Burschka schrieb:
>>Namely the thirteenth of December 1901, 12:45:52, Pacific Time.
All dates later than this passed in format "yyyy-mm-dd hh:mm:ss" to the strtotime function return the correct unix timestamp value (as can be verified by passing it back to date()).
If a date earlier than 1901-12-13 12:45:52 is used, it returns an error. I tried this for a while to find the exact cut-off point, and this is it.
Any reason - possibly a limitation of the integer value that is used? I didn't find this documented anywhere...
Whoops, I should have checked more closely. In fact this *is* documented as the minimal value of most dates due to the length of the 32-bit integer.
I never considered that these "Y2K" problems work backwards, too...
The upper end of this range is coming up as well, in the middle of
February, 2038.
And that's sooner a problem then you think. What if you want to calculate
new mortgages? That's a field where 2038 is very, very close...
--
Rik Wasmus This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Beckett |
last post by:
I have successfully used strtotime to format the date on a webpage that is
pulled form a MySQL database in the form yyyy-mm-dd.
However, in another part of the webpage, I have to insert another...
|
by: Craig Thomson |
last post by:
I'm using strtotime to validate a date/time passed in from a form but
am having some problems with it. It seems to allow invalid values,
such as "2004-04-13 21:66:13".
Does anyone know why this...
|
by: Leif K-Brooks |
last post by:
PHP has a very nice strtotime function (http://php.net/strtotime) which
converts a date/time in virtually any format into a timestamp. Does
Python have a similar function?
|
by: Rithish |
last post by:
Hello. I noticed a strange thing while using strtotime() and date()
functions in combination to generate from MySQL into a readable format.
By default, the MySQL date field will be 0000-00-00...
|
by: windandwaves |
last post by:
Hi Folk
I love the strtotime function, because I can make a date field in a form and
just tell my users to enter whatever they want and as long as it is a date,
it will work.
HOWEVER, this...
|
by: cassbiz |
last post by:
I am using strtotime and I have read up on some examples and am getting the wrong output, it jumps by several days instead of one day at a time.
Ultimately what I am trying to accomplish is to set...
|
by: Chris |
last post by:
I am trying to output Monday of the current week i.e. if Monday is the
8th I want to display 'Monday 8th' for any date between Monday 8-14th.
I would appreciate any help, the code below is...
|
by: Anthony Smith |
last post by:
So, after doing some research I finally figured that php chokes on
dates past year 2525. In this web service that I use they often use
2525-05-31 as the expiration date. I want to determine how I...
|
by: Erwin Moller |
last post by:
Hi group,
I have been using strtotime a lot in my code.
I wonder if I made a mistake in my thinking. :-/
Here follows a stripped down example.
consider some dates:
$date1 = "2008-02-23";...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |