converting between date formats

Question

how would you convert a date stored as

2011-01-18 11:51:41

into

18-01-2011 11:51:41

using PHP?

many thanks in advance!

A date is not stored as anything but just a date. How it looks depends on display formatting. Internally a data is just a number (unless you store it as a string/varchar, in which case it it not a date). — GolezTrol
– GolezTrol, Commented Jul 26, 2011 at 20:28

barfoon · Accepted Answer · 2011-07-26 20:28:11Z

5

date('d-m-Y H:i:s', strtotime('2011-01-18 11:51:41'));

answered Jul 26, 2011 at 20:28

28.4k29 gold badges97 silver badges140 bronze badges

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

1 Comment

The problem with this is that on 32-bit servers dates after 2038 will become January 1st 1970.

Marc B · Accepted Answer · 2011-07-26 20:31:33Z

More reliable than using strtotime(), assuming you're on PHP 5.3+

$oldtime = date_parse_from_format('Y-m-d h:i:s', '2011-01-18 11:51:41'); $newtime = date('d-m-Y h:i:s', $time);

However, the date format you're converting FROM suggests it's coming from a MySQL datetime field, in which case you could also do:

SELECT DATE_FORMAT(yourfield, '%d-%m-%Y %H:%i:%s')

and save yourself a full roundtrip in PHP.

Michael Berkowski · Accepted Answer · 2011-07-26 20:27:01Z

Convert the old date to UNIX time with strtotime(), then output it in the new format with date()

$olddate = "2011-01-18 11:51:41"; $newdate = date('d-m-Y H:i:s', strtotime($olddate)); echo $newdate; // 18-01-2011 11:51:41

genesis · Accepted Answer · 2011-07-26 20:27:22Z

2

$your_date = "2011-01-18 11:51:41"; echo date('d-m-Y H:i:s', strtotime($your_date));

answered Jul 26, 2011 at 20:27

51.1k20 gold badges99 silver badges127 bronze badges