Turning date fields into actual dates

[downah]

I have got a date field in my mysql database with events, and as you know date in MYSQL uses yyyy/mm/dd but I would first like to turn this around to dd/mm/yyyy but also turn this into for example "Tuesday - May 1990" would anyone like to point me into the right direction?

 

Much appreciated!

[AyKay47]

In the SQL, use UNIX_TIMESTAMP() to convert the daytime field to a TIMESTAMP, then use the php function date to format it.

[downah]

Thanks for the help, at the moment I am first trying to turn yyyy/mm/dd around to dd/mm/yyyy with this:

 

$date = $row['eventdate'];

  echo "<td>" . date('d-m-Y',$date) . " " . $row['starttime'] . "</td>";

 

which puts it into dd/mm/yyyy great! although it is not showing the right dates! but automatically all dates seemed to change to 01/01/1970.. know why?

[AyKay47]

Re-read my first reply, the date() function requires a TIMESTAMP as the second argument. You need to convert the datetime field into a TIMESTAMP using unix_timestamp()

[litebearer]

easier to use mysql's date formating function

http://www.electrictoolbox.com/article/mysql/format-date-time-mysql/

[downah]

$date = $row['eventdate'];
$my_date = strtotime($date); 


  echo "<td>" . date('d-m-Y',$my_date) . " " . $row['starttime'] . "</td>";

 

Mmm I thought this would do it, but still showing the 01-01-1970

[downah]

I got it to work using:

 

  echo "<td>"; 
print date('d M Y', strtotime($row['eventdate']));
echo " ";
echo $row['starttime'] . "</td>";

 

Thanks guys, although I'd still like to know why this doesn't work if anyone could point that out?

 

$date = $row['eventdate'];
$my_date = strtotime($date); 


  echo "<td>" . date('d-m-Y',$my_date) . " " . $row['starttime'] . "</td>";