Incorrect value of datetime PHP and MySQL

Question

In my site, I have a bootstrap datepicker which allows user to pick date in format of MM/DD/YYYY (e.g: 05/12/2014). Then when this data is submitted, I used the following PHP code to convert it into Datetime type, then insert into start_date (DATETIME datatype) column in MySQL .

$start_date = date('Y-m-d', $_POST['start_date']);

the insert query in PHP does nothing with reformatting the date. It just simply insert into corresponding column.

However, instead of inserting '2014-05-12', the value inserted into database is '1970-01-01'. That's so weird to me. Can anybody tell me what's wrong here. Is this that I used incorrect PHP function or incorrect timezone setting or ...

manlikeangus · Accepted Answer · 2014-05-12 04:25:39Z

2

Just do this:

$start_date = date('Y-m-d', strtotime($_POST['start_date']));

answered May 12, 2014 at 4:25

manlikeangus

42111 silver badges29 bronze badges

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

2 Comments

DucCuong Over a year ago

Thanks it works correctly. Perhaps, next time I will google more before asking such silly questions like this

DucCuong Over a year ago

Of course, but stackoverflow only allows me to accept correct answer in few minutes later (about 5 mins to go)

Ryan Kempt · Accepted Answer · 2014-05-12 04:25:11Z

1

You could also use strtotime() on your $_POST.

$start_date = date('Y-m-d', strtotime('05/12/2014'));

answered May 12, 2014 at 4:25

Ryan Kempt

4,2096 gold badges32 silver badges41 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:27:13Z

1

try to use

$date = str_replace('/', '-', $_POST['start_date']);
$start_date = date('Y-m-d', strtotime($date));

For more :- Converting between illogically formatted dates (changing /slash/ to -dash- )

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered May 12, 2014 at 4:29

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Collectives™ on Stack Overflow

Incorrect value of datetime PHP and MySQL

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related