British date format parsing
During the PHP London conference (slides are here as usual), a number of British people were "complaining" that PHP's strtotime() and date_create() /new DateTime() functions do not understand the British date format "dd/mm/yyyy". Historically, the "English" text to date parsers in PHP only accept the illogical American format of "mm/dd/yyyy". Having seen this problem before, I recently added a new function/method to PHP's Date/Time support to address exactly this issue. From PHP 5.3 the new date_create_from_format() function and the DateTime::createFromFormat() factory method are available. As first argument they accept the expected format, and as second argument the string to parse. To parse a British date string, you would for example use:
<?php $dt = date_create_from_format( 'd/m/Y', "02/03/2008" ); echo $dt->format( 'd/m/Y' ), "\n"; ?>
In case the passed string does not match the format, the function will return false. With the also new function date_get_last_errors() method you then can request more information about which part of the string could not be passed. The following example illustrates that:
<?php
$dt = date_create_from_format( 'Y-m-d', "02/03/2008" );
if ( !$dt )
{
$errors = date_get_last_errors();
var_dump( $errors['errors']);
}
?>
The $errors contains a list of errors, indexed by the position in the string where the error was found. The above script would produce:
array(3) {
[2]=>
string(22) "Unexpected data found."
[5]=>
string(22) "Unexpected data found."
[8]=>
string(13) "Trailing data"
}
The format specifiers are mostly similar to the ones used for the date() function. Documentation on the new functions should make it into the documentation soon.
Comments
Thats great news.. the strtotime format was always a bit too magical to me =)
Fan-bloody-tastic. Well done old chap!
Thanks Derek!
With a useful title as well, so I can find it again when I google for it!
Rob...
It's not a "British" format, it's the normal format used everywhere. The American format is the odd one out ;)
Hi!
Thank you - being one of those annoying people who pestered you for this, I'm much appreciative of your hard work :)
Thanks! David.
Now if we could just get that pesky $ at the beginning of every variable to be a £ then we'd be talking.
any chance this gets released as a legacy class or in PEAR compat? This would be so damn usefull if it weren't for being only available in 5.3
Anyway, damn nice job derick!
Thanks Derick,
Really useful addition, I've always had to convert the dates manually. i.e
Thanks
@DewiMorgan: Definitely want to avoid adding flags, as there could be many. I wouldn't be able to do that for PHP 5.2 anyway, and PHP 5.3 has a better solution in the form of date_parse().
Can't say for sure, since I've not used it (still on 5.2 here) but date_parse() seems to be "better" only in as much as it has the exact same problem, so would need the exact same fix. From the manual:
"Date in format accepted by strtotime()."
If flags for critical functionality like this are out of the question (other than all the flags that have already been added to other functions, of course) then maybe a config setting, "make the date functions respect my locale"?
@Dewi: Sorry, meant DateTime::createFromFormat (http://no.php.net/manual/en/datetime.createfromformat.php)
Life Line
@beasts Is your ns1 doing OK? I am getting warning from monitoring that it is timing out and having different results than ns2.
Updated a restaurant
I walked 8.5km in 1h50m50s
I consider myself a decent photographer, but then you find out about the likes of Angel Fux (https://www.angelfux.com/portfolio), and I would like to crawl into a hole.
Better alignment from multiple GPS tracks for QE II Garden (and removed duplicated node)
After two busy days doing elections stuff, I spent yesterday looking at birds, in a nature reserve to relax and recharge.
I saw some cracking birds, with these being my favourite shots.
#BirdPhotography #photography #BirdsOfMastodon #Nature #London
I walked 8.0km in 1h26m01s
Updated a restaurant
Updated 3 bird_hides; Confirmed 2 informations and a toilet
I walked 7.0km in 3h10m47s
This map was mostly red yesterday.
I'm glad we managed to win all the wards we've targeted.
However, no overall control, and two parties with the same amount of seats in second place.
I walked 2.2km in 41m46s
I walked 1.9km in 19m17s
I've spend most of my time outside polling telling today, taking down poll card numbers so we don't need to chase people up to go vote.
I have made several observations:
Updated a restaurant
I walked 12.1km in 2h3m04s
I walked 1.1km in 9m46s
I walked 1.2km in 10m31s
Updated a waste_basket
Created 11 benches, 2 life_rings, and 3 other objects; Updated 8 benches and a waste_basket; Deleted a bench and a log; Confirmed a cafe
I walked 7.8km in 1h52m27s
Tomorrow we have elections in the UK!
Lots of local authorities, all London Councils, the Welsh Senedd, and the Scottish Parliament.
Don't forget to vote if you have the right.
I get to vote for myself again 😎.
Benches, and corrections for the QE II Gardens
Addresses on College Road
Created 2 main entrances and an entrance; Updated an entrance, a residential building, and a house building
Shortlink
This article has a short URL available: https://drck.me/bdfp-68x