Parsing dates
For some reason I started maintaining PHP's strtotime() function, which parses a strings containing a date/time representation, such as "2004-04-18 17:59 CEST", "April 18, 2004" and the like. With so many different formats one guy in the past crafted a parser for this basing the syntax on GNU tar . The original function had some problems, or was missing some formats (such as the highly useful ISO 8601 formats) and during time this original parser was extended. it might have been a nice and simple bison parser, with a hand craften lexer, but I can assure you that it is now shitty, buggy and totaly unmaintainable. Nobody knows what formats it's supposed to parse either.
With those four problems in my head I decided to redo this shitty old and messy parser by using re2c to do the parsing. Their is a problem though as I don't know which format it's supposed to parse at all (except the GNU tar things and ISO 8601 stuff) so I'm asking you guys which formats it should be able to parse, and which formats you already parse with the strtotime() function.
Comments
This one's odd because the time comes before the year, but it's the locale standard.
$ date +"%c" Sun Apr 18 18:36:57 2004
- These are the only strtotime formats I already use:
-
strtotime ("+20 minutes") strtotime ("+3 month") strtotime ("Monday") strtotime ("2001-10-24 15:22:13")
I think it would be good to be able to parse the default timstamp and date formats for postgresql, mysql and probably oracle and mssql. I only use postgresql so I can only point you here:
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html
Parsing anything that a database could spit out would be great...
culley
Like culley's suggestion regarding database date formats, consider also typical
webserver log date formats. For example, for Apache's logs: http://httpd.apache.org/docs/logs.html http://httpd.apache.org/docs-2.0/logs.html
Also, how about operating system timestamps: http://weblogs.asp.net/oldnewthing/archive/2003/09/05/54806.aspx
There may be some good clues in the GNU C Library: http://www.gnu.org/software/libc/manual/html_node/Calendar-Time.html#Calendar%20Time
Maybe some clues here in POSIX Locale: http://www.opengroup.org/onlinepubs/007908799/xbd/locale.html#tag_005_003_005
Here are some additional database date and time function format references: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html http://otn.oracle.com/tech/blaf/specs/commonFormats.html http://www.sswug.org/searchresults.asp?keywordstofind2=date%20time
For me, the most useful things about strftime() are doing relative date math ("+2 days") ("1 sunday ago") that properly accounts for DST switches and stuff based on days of the week ("next Monday").
Life Line
TIL that Kingfishers can hover just like hummingbird. I'll hopefully have some reasonable shots after I've gone through my nearly thousand shots today...
I hiked 9.8km in 3h40m47s
Updated a restaurant
Updated a vacant business
I walked 7.1km in 1h16m56s
I walked 3.9km in 45m56s
I walked 1.1km in 10m47s
I think this was my favourite photo of the set that I took. It's not at maximum coverage, but it does have a sun spot group (4508) just on the cusp of the terminator.
#eclipse #eclipse2026 #SolarEclipse #London #Astronomy #AstroPhotography #Photography
No totality here in London, but still had a great evening out in the local park and taking some snaps.
I did have a nice Solar Filter that I made for my lens, and had many conversations with people from different backgrounds. Kids loves to look through my filter after I was done (ran out of battery power).
More photos later...
#london #eclipse2026 #eclipse #photography
I walked 0.9km in 9m28s
I walked 1.2km in 19m05s
Merged pull request #1100
Fixed issue #2267: Application slow when debugger is not listening on…
I walked 4.7km in 48m18s
I walked 3.0km in 1h10m24s
Is there somebody who runs PHP on native windows (with Xdebug) and can run a simple script for me?
It must be in a file (`test.php`):
```
<?php
echo microtime(true), "\n";
xdebug_connect_to_client();
echo microtime(true), "\n";
```And run like:
php -dxdebug.log_level=11 -dxdebug.log=c:\temp\xdebug-i.log -dxdebug.client_host=localhost -dxdebug.client_port=9111 -dxdebug.mode=debug c:\temp\test.php
With the port 9111 not open.
Would love to see the output and log file (in a DM).
I walked 5.5km in 55m06s
@harry_wood This is this list of 100 Go-mistakes that I was talking about: https://100go.co/
Updated a crossing
I walked 2.1km in 20m08s
Enjoying my afternoon and evening out at Lords for some cricket!
I walked 3.2km in 38m54s
I walked 9.1km in 1h34m28s
Updated a gate
Updated a bakery shop
Shortlink
This article has a short URL available: https://drck.me/parsing-dates-37r