Transform date to valid format for PostgreSQL with PHP

Question

I have a string in this format:

Thu, 26 Feb 2015 11:39:59

And I wonder if its possible to transform it to a valid timestamp format in order to insert it in my PostgreSQL database.

So ideally in the end I would have something like:

2015-03-26 11:39:59

Is there a function in PHP to do something like this?

Sougata Bose · Accepted Answer · 2015-05-14 09:51:22Z

9

Use DateTime() to format date string.

$date = 'Thu, 26 Feb 2015 11:39:59';

$date = new DateTime($date);

echo $date->format('Y-m-d H:i:s');

answered May 14, 2015 at 9:51

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

2 Comments

user1919 Over a year ago

Thanks. That worked. I was not aware of this function and I was ready to do it with a much more complicated way.

Paradox Over a year ago

Sidenote: to get the current date formatted as input to DateTime, use date("Y-m-d h:m:s")

Narendrasingh Sisodia · Accepted Answer · 2015-05-14 09:57:11Z

2

You can also use it as DateTime::createFromFormat

$date = 'Thu, 26 Feb 2015 11:39:59';
$date = DateTime::createFromFormat('D, d M Y H:i:s', $date);
echo $date->format('Y-m-d H:i:s'); //2015-03-26 11:39:59

answered May 14, 2015 at 9:57

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Collectives™ on Stack Overflow

Transform date to valid format for PostgreSQL with PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related