PHP SQL Datetime issue

Question

I have a DATETIME field within a SQL table and retrieve the data accordingly - when trying to use the date_diff function however I receive the following message:

Message: date_diff() expects parameter 1 to be DateTime, string given

is there a way to convert the string I have taken from the SQL DB back into a date/time, the field format is as follows:

Y    -M -D H -M -S   
2014-02-15 14:55:29

If you show the SQL query, you can probably do the date diff in the database. — Gordon Linoff
– Gordon Linoff, Commented Feb 15, 2014 at 15:20

John Conde · Accepted Answer · 2014-02-15 15:09:35Z

2

You are passing the datetime string to date_diff() but that function expects a DateTime() object. You need to create a DateTime() object with the date first, then use date_diff().

$date1 = new DateTime('2014-02-15 14:55:29');
$date2 = new DateTime();
$interval = $date1->diff($date2);

answered Feb 15, 2014 at 15:09

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

mehmetseckin · Accepted Answer · 2014-02-15 15:09:26Z

1

This should work :

$datetime = DateTime::createFromFormat('Y-m-d H:i:s', '2014-02-15 14:55:29');

answered Feb 15, 2014 at 15:09

mehmetseckin

3,1371 gold badge34 silver badges44 bronze badges

1 Comment

John Conde Over a year ago

createFromFormat is unecessary as that date format is readable by DateTime()

Collectives™ on Stack Overflow

PHP SQL Datetime issue

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related