Page 1 of 1

[SOLVED] need help in query....

Posted: Mon Jan 02, 2006 6:42 am
by itsmani1
i want to select date as 4 jan 2004
from
table=> test
and
column => dob

can any one help me in query.

Posted: Mon Jan 02, 2006 6:47 am
by itsmani1
i get it.
here is the answer

Code: Select all

SELECT date_format( dob, '%a %D %b %Y' ) AS formatted_date
FROM test