[SOLVED] need help in query....

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

[SOLVED] need help in query....

Post by itsmani1 »

i want to select date as 4 jan 2004
from
table=> test
and
column => dob

can any one help me in query.
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

Post 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
Post Reply