i want to select date as 4 jan 2004
from
table=> test
and
column => dob
can any one help me in query.
[SOLVED] need help in query....
Moderator: General Moderators
- itsmani1
- Forum Regular
- Posts: 791
- Joined: Mon Sep 29, 2003 2:26 am
- Location: Islamabad Pakistan
- Contact:
i get it.
here is the answer
here is the answer
Code: Select all
SELECT date_format( dob, '%a %D %b %Y' ) AS formatted_date
FROM test