I have dates in the following format (yyyymmdd, 18751104, 19140722)... what's the easiest way to convert it to date().... or is using mktime() and substrings my best option...?
Use strtotime()
to convert a string containing a date into a Unix timestamp:
<?php
// both lines output 813470400
echo strtotime("19951012"), "\n",
strtotime("12 October 1995");
?>
You can pass the result as the second parameter to date()
to reformat the date yourself:
<?php
// prints 1995 Oct 12
echo date("Y M d", strtotime("19951012"));
?>
strtotime()
will fail with dates before the Unix epoch at the start of 1970.
As an alternative which will work with dates before 1970:
<?php
// Returns the year as an offset since 1900, negative for years before
$parts = strptime("18951012", "%Y%m%d");
$year = $parts['tm_year'] + 1900; // 1895
$day = $parts['tm_mday']; // 12
$month = $parts['tm_mon']; // 10
?>
Personally, I'd just use substr() because it's probably the lightest way to do it anyway.
But here's a function that takes a date, of which you can specify the format. It returns an associative array, so you could do for example (untested):
$parsed_date = date_parse_from_format('Ymd', $date);
$timestamp = mktime($parsed_date['year'], $parsed_date['month'], $parsed_date['day']);
http://uk.php.net/manual/en/function.date-parse-from-format.php
Although I must say, I don't find that any easier or more effective than simply:
mktime(substr($date, 0, 4), substr($date, 4, 2), substr($date, 6, 2));
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With