I'm trying to convert given string in format 1899-12-30 19:00:00.000 to date using this function:
$startDate = strtotime("1899-12-30 19:00:00.000");
but as a result I get a wrong date, e.g.
30.10.2008 00:00:00
what am I doing wrong?
3 Answers
Use DateTime:
$date = DateTime::createFromFormat( 'Y-m-d H:i:s.u', '1899-12-30 19:00:00.000', new DateTimeZone( 'America/New_York'));
echo $date->getTimestamp() . ' ' . $date->format( 'Y-m-d H:i:s');
Note that this will be a negative value since it's before Jan 1st, 1970. The above code outputs:
-2209093200 1899-12-30 19:00:00
Make sure you set the correct timezone in the constructor to DateTimeZone (or you can omit it to leave it as default).
Comments
if you are using PHP 5 >= 5.3.0 you can use date_parse_from_formatDocs function like this:
$date = "1899-12-30 19:00:00.000";
$dateObj = date_parse_from_format("Y-m-d H:i:s.000",$date);
Source : php.net
1 Comment
nickb
I don't believe your format string is correct - It does not return the correct results in my test.
The date 1899-12-30 19:00:00.000 is represented by the UNIX timestamp -2209096800, which is just outside the range of a 32 bit signed integer. On a 64 bit PHP system it will work, on a 32 bit system you'll run into problems.
Use the DateTime class to represent such dates, it can handle it.
Comments
[i]be[$i]?