Thread: Just display the month?
View Single Post
  #2 (permalink)  
Old Feb 3rd, 2008, 12:53
Marc's Avatar
Marc Marc is offline
Moderator

SuperMember
Join Date: Apr 2007
Location: Scotland, UK
Age: 15
Posts: 1,662
Thanks: 0
Thanked 9 Times in 9 Posts
Re: Just display the month?
Just change:
date_format(date, '%M %D, %Y') AS date to date_format(date, '%M') AS date..

Will that not work?
Reply With Quote