Page 1 of 1

date format help

Posted: Tue Dec 03, 2002 2:21 pm
by CrazyJimmy
I'm trying to format my date but it does'nt like it :(

select DATE_FORMAT(c.date, '%W %M %Y') c.name from cd as c, track as trk where trk.album_id=c.id AND trk.name='Darkness On The Edge Of Town'

any ideas?

Posted: Wed Dec 04, 2002 4:06 am
by twigletmac
Try:

Code: Select all

SELECT DATE_FORMAT(c.date, '%W %M %Y') AS date, c.name FROM cd AS c, track AS trk WHERE trk.album_id=c.id AND trk.name='Darkness On The Edge Of Town'
Mac