[SOLVED] Date and time conversion question

[simonp]

In my db I'm storing the date and time as date('YmdHi') eg:

 

200908141659

 

When I get the info from the db - I want to display it as:

 

16:59 14/08/2009

 

How would I go about doing that?

 

Cheers

 

Simon

[JonnoTheDev]

Is there a reason for storing the date in this fashion. Really you should use an INT(10) and use a UNIX timestamp. This value can be converted back to date & time using php's date() function.

 

Timestamp

print time();

[Daniel0]

You should store it as a DATETIME field.

 

You can do like this though:

<?php
$time = 200908141659;

$unix = mktime(substr($time, 8, 2), substr($time, 10, 2), 0, substr($time, 4, 2), substr($time, 6, 2), substr($time, 0, 4));

echo date('H:i m/d/Y', $unix);

[simonp]

Thanks guys - went with the unix timestamp (time()) option (which I should have done in the first place!)

 

All working.

 

Cheers

 

Simon