Best way to convert Apachelog Datetime 01/Jan/2016:02:25:10 -> 2016-01-01 02:25:10 MySQL-Datetime Format

Martin Tschierschke via Digitalmars-d-learn digitalmars-d-learn at puremagic.com
Wed Jun 8 05:39:37 PDT 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 ?


More information about the Digitalmars-d-learn mailing list