PHP: convert date format yyyy-mm-dd => dd-mm-yyyy [NOT IN SQL]

Question

hey guys,

i am trying to convert a date from yyyy-mm-dd to dd-mm-yyyy however i dont know how the date function requires a timestamp and i cant get a timestamp form this string...

anyone an idea?

thanks Matthy

Answer 1

$timestamp = strtotime(your date variable); 
$new_date = date('d-m-Y', $timestamp);

For more:

http://php.net/manual/en/function.strtotime.php

Or even shorter:

$new_date = date('d-m-Y', strtotime(your date variable));

Answer 2

Use strtotime() and date():

$originalDate = "2010-03-21";
$newDate = date("d-m-Y", strtotime($originalDate));

(see strtotime and date docs on the PHP site).

Answer 3

I think this is function in Php that you need. strtotime. http://php.net/manual/en/function.strtotime.php

How do u need the date in Mysql format?

Answer 4

You can try strftime function. Something like strftime ($time, '%d %m %Y') More here

Answer 5

Also another obscure possibility:

$oldDate = '2010-03-20'
$arr = explode('-', $oldDate);
$newDate = $arr[2].'-'.$arr[1].'-'.$arr[0];

i don't know would use it but still :)

Answer 6

implode('-', array_reverse(explode('-', $date)));

Without date conversion overhead, not sure it'll matter much.