date display!

sirTemplar

help again!

i have this code to search my database

$result = mysql_query ("SELECT * FROM table
WHERE BDATE BETWEEN '2002-01-01' AND '2002-12-31'
AND SDATFIN1 = ' '
AND MORTDAT1 = ' '
ORDER BY SACDAT ASC, CNOMEN
",$conn);

the bdate field in my database is "date" format. what should i do so that on the output it will show the date as eg. Dec. 13, 2002 instead of 2002-12-13? thanks for anyone out there willing to help!

nnichols

Read the section in the MySQL manual about "DATE_FORMAT()"

bastien

echo bdate ("M j Y");

hth

volleytotal_ch

try this to let mySQL format the date (rather tha php):

SELECT DATE_FORMAT(your_date_col, '%b. %e, %Y');
FROM table;

for more infos see mysql.com -> doc 6.3.4

hth

sirTemplar

do you mean writing something like this:

$result = mysql_query ("SELECT * FROM table
WHERE BDATE BETWEEN '2002-01-01' AND '2002-12-31'
AND SDATFIN1 = ' '
AND MORTDAT1 = ' '
ORDER BY SACDAT ASC, CNOMEN
",$conn);

SELECT DATE_FORMAT(your_date_col, '%b. %e, %Y');
FROM table;