Php extract date for mysql

Question

I am trying to convert a date that I parse from a file "September 2, 1904" . How can I convert that to MySQL date format for be able to insert it in MySQL? If insert it like this i get "0000-00-00" in MySQL

I tried something like :

$date = DateTime::createFromFormat('j-M-Y', $data[11]);
            //echo $date->format('Y-m-d');

Thanks in advance

If you use createFromFormat, you have to make the format match the date that you read from the file. j-M-Y is for 2-09-1904, not September 2, 1904. — Barmar
– Barmar, Commented Feb 17, 2016 at 22:55

jonasfh · Accepted Answer · 2016-02-17 22:55:59Z

2

I usually rely on strtotime to parse dates if the format can be trusted...

echo date("Y-m-d",strtotime("September 2, 1904"));

answered Feb 17, 2016 at 22:55

jonasfh

4,6572 gold badges24 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

davejal Over a year ago

please also mark as answered as other users of SO can learn from it or can see that it is resolved.

Sam Orozco · Accepted Answer · 2016-02-17 22:55:53Z

0

I think you're looking for something like this?

mktime(0,0,0,9,2,1904)

answered Feb 17, 2016 at 22:55

Sam Orozco

1,2681 gold badge13 silver badges32 bronze badges

Collectives™ on Stack Overflow

Php extract date for mysql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related