EasyCFM.COM ColdFusion Forums / MySQL Related Issues / Date Format

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Date Format

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

cdbymike
03-26-2005 @ 4:37 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 97
Joined: Jul 2004

When I run a query and want to froup by month. I would like to display the Month Name. Can someone help me on formating this?

Data is stored in db as: 2005-03-05

megan
03-26-2005 @ 7:35 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

did you try the DateFormat() function ? e.g. #DateFormat(now(), "mmmm")#

~megan


We have art so that we shall not die of reality ~ Nietzsche

cdbymike
03-26-2005 @ 8:40 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 97
Joined: Jul 2004

Thanks, I was trying to figure it out in MySQL. Didn't realize that I could get what I needed on the CF side.

Thanks again.


Website Designed and Developed by Pablo Varando.