date format help

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
CrazyJimmy
Forum Commoner
Posts: 34
Joined: Tue Nov 19, 2002 1:40 pm

date format help

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

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