Converting dates

[beanwebb]

Hi,
I have a problem with changing the format of dates. I use MySQL databases and I have my date field set to 'DATE', my problem is, when I use php to get this from the database and add it to my site it comes out as 2003-01-11, My question is, is it possible to change the format of the date so it would instead read 11-Jan-2003? Thanks in advance for any help.

[seby]

$variable = date("d-M-Y");

[xblue]

beanwebb,

use DATE_FORMAT in your mysql query.

SELECT DATE_FORMAT(date_column_name, '%d-%b-%Y') AS name_to_access_data_with FROM ...

For formatting options see
http://www.mysql.com/doc/en/Date_and_time_functions.html

Hope this helps,
xblue

[intenz]

Try...

$timestamp = strtotime( $myrow['date'] );
echo date( 'd.m.Y - H:i:s', $timestamp );