digitalmars.D.learn - Best way to convert Apachelog Datetime 01/Jan/2016:02:25:10 ->
- Martin Tschierschke (6/6) Jun 08 2016 I know there are easy ways to handle this,
- Martin Tschierschke (8/10) Jun 08 2016 I found this solution, letting the MySQL engine do the work:
I know there are easy ways to handle this, anyone with a code snippet for me? I would use two regex first to make 01,02,03... from Jan,Feb,.. and second to split the result. best regards mt.
Jun 08 2016
On Wednesday, 8 June 2016 at 10:42:19 UTC, Martin Tschierschke wrote:I know there are easy ways to handle this, anyone with a code snippet for me?I found this solution, letting the MySQL engine do the work: SELECT STR_TO_DATE('26/Apr/2011:13:21:58', '%d/%b/%Y:%H:%i:%S'); https://www.experts-exchange.com/questions/26992776/convert-apache-log-date-time-to-mysql.html Maybe there is an other short solution using the std.datetime and or https://code.dlang.org/packages/dateparser ?
Jun 08 2016