Page 1 of 1

Displaying date from SQL database

Posted: Wed Jul 21, 2004 5:16 am
by mjseaden
Dear All,

I have a date stored in a MySQL database which I am simply 'echoing' to display on my webpage. However, when I echo is, it displays in YYYY-MM-DD format, whereas I want it displayed in DD-MM-YYYY format, or even '23rd March 2004' format.

Can anyone tell me if it's a MySQL query syntax I need to use or a PHP function acting on the date?

Many thanks

Mark

Posted: Wed Jul 21, 2004 5:20 am
by qads

Code: Select all

<?php
$date = explode("-", "YYYY-MM-DD");
list($year, $month, $day) = $date;
echo "$day-$month-$year";
?>

Posted: Wed Jul 21, 2004 5:32 am
by feyd
Personally, I'd ask MySQL to return a UNIX_TIMESTAMP or reformat it using stuff from: Date and Time functions

Posted: Wed Jul 21, 2004 8:15 am
by liljester
you can do php or you could let MYSQL format it for you.

Code: Select all

SELECT DATE_FORMAT(my_date_field, "%d-%m-%Y") AS format_date FROM table;
http://dev.mysql.com/doc/mysql/en/Date_ ... tions.html