php date to sql

Question

I want to store php date in sql but it store 1970-01-01 05:00: instead of input datetime

This is html form

<input type="datetime" id="eventstart" name="txtEventStart" class="form-control" value="<?php echo date('m/Y/d h:i:s');?>">

when data is sent using post

$date = $this->input->post('txtEventStart');

I convert string to date format using:

$date2 = date('Y-m-d H:i:s', strtotime($date));

It stores '1970-01-01 05:00:00'

I want to know what is the correct format for storing such type of date.

Nick · Accepted Answer · 2019-08-20 00:28:01Z

1

Your code is giving you the wrong results because your date is in a format (m/Y/d h:i:s) that is not recognised by strtotime. Instead, use date_create_from_format to convert it and output a date in the correct form for SQL. For example:

$date = '08/2019/19 10:23:41';
echo date('Y-m-d H:i:s', strtotime($date)) . PHP_EOL;
echo date_create_from_format('m/Y/d h:i:s', $date)->format('Y-m-d H:i:s');

Output:

1970-01-01 01:00:00
2019-08-19 10:23:41

Demo on 3v4l.org

answered Aug 20, 2019 at 0:28

Nick

147k23 gold badges67 silver badges106 bronze badges

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

Comments

Aiden · Accepted Answer · 2019-08-20 00:07:03Z

0

'YYYY-MM-DD hh:mm:ss' is not an acceptable format for PHP date function. Use Y-m-d H:i:s instead. More info here: https://www.w3schools.com/php/func_date_date.asp

Update: For date input field use ISO date format Y-m-d or change input type to 'text'

edited Aug 20, 2019 at 0:07

answered Aug 19, 2019 at 23:51

Aiden

3606 silver badges22 bronze badges

4 Comments

Waqas Kanju Over a year ago

the one you are suggesting is already tried. it shows '1970-01-01 05:00:00'

Aiden Over a year ago

You must also use the same format for the 'datetime' input field. Or you can change the input type to 'text'.

Waqas Kanju Over a year ago

dear Aiden there is on need to use the same format, one format can be converted to other

Aiden Over a year ago

Although I can see that the issue was in your strtotime function, I would like to mention that datetime input format is no longer supported by most browsers. If you would like to set a value for an input type of "date" you MUST use ISO format, m/Y/d format will not be displayed by date input field. This is demonstrated here: onlinegdb.com/BkiOV3t4r

Collectives™ on Stack Overflow

php date to sql

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related