DATETIME output help.

[virtuexru]

OK, so into my database, one table goes in DATETIME with default format being: 0000-00-00 00:00:00.

 

When I output, how can I convert this to something like -

 

06/12/99 @ 12:00PM

 

or even -

 

June 21st, 1987 @ 12:00PM

 

??

[trq]

Take a look at the date and related functions / examples.

[obsidian]

First option: use the MySQL DATE_FORMAT() function.

 

Second option: use PHP

<?php
$ts = '2007-02-14 12:00:00';
echo date('F js, Y @ g:ia', strtotime($ts));
?>

 

Good luck.

[Glyde]

Combination of strtotime() with date().  But if the field is DATETIME you should be able to use MySQL to format the date for you.

[clown[NOR]]

this is how I've done it:

<?php
function formatDate($date)
{
	$date = explode("-", $date);
	$date = date("d. F, Y", mktime(0, 0, 0, $date[1], $date[2], $date[0]));
	$enMonthArray = array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
	$noMonthArray = array('Januar', 'Februar', 'Mars', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Desember');
	return str_replace($enMonthArray, $noMonthArray, $date);
}
function formatTime($time)
{
	$time = explode(":", $time);
	return $time[0].":".$time[1];
}
?>