Converting Datetime into UK date format

dakey

Hello does anyone now how to convert the datetime i get from the mysql database in the UK format.

e.g
2005-09-18 21:00:06 into 18-09-2005 21:00:06
YYYY-MM-DD HH:MM:SS into DD-MM-YYYY HH:MM:SS

Many thanks,
Martin

kbduvall

$uk_time = $date("d-m-Y H:i:s", $your_mysql_timestamp);

🙂

dakey

Sorry but i can't get that to display the right date. To confirm

//This is extracted from a MySql database who's field type is set to DATETIME
$date="2005-09-18 21:00:06";

//But i want to convert this into the UK format like
$UKdate="18-09-2005 21:00:06";

rikmoncur

I've got this snippet in my snippety bits - where $date is your sql datestamp:


list($year, $month, $day)= explode("-", $date);
	$uk_date=date(" d F  Y", mktime(0,0,0,$month,$day,$year));
echo ( " $uk_date " );

OR - I bung this into my sql statement:

SELECT DATE_FORMAT( Your_Date,'%d %b %Y') AS Your_Date

They output eg: 26 February 2005

dakey

Thats great, but although the date is now displayed correctly it's missing the time!

rikmoncur

http://uk2.php.net/strftime

plambert

$date = '2005-09-18 21:00:06';
list($year, $month, $day) = explode("-", substr($date,0,10));
list($hour, $minute, $second) = explode(":", substr($date,11,8));
$uk_date = date("d-m-Y H:i:s", mktime($hour,$minute,$second,$month,$day,$year));
echo $uk_date;

Weedpacket

dakey wrote:
Thats great, but although the date is no displayed correctly it's missing the time!

Which is why we have things called manuals...
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html#id3072376

pete116

this thread was probably finished with a LONG time ago, but i found it in a google search when looking for something else and i have a solution for it 🙂

it goes as follows:

$ukdate = gmdate('H:i:s d-m-Y', $your_mysql_time);

This asumes the date comes in the same format as time(); ??

Pete