Comma in MySQL date output

Struggling with PHP or HTML? Got any tips? Drop in here to share your questions and answers. Newbies and gurus welcome!
Post Reply
User avatar
sohel2009
Rank 0
Rank 0
Posts: 1
Joined: September 19th, 2009, 4:09 am

Comma in MySQL date output

Post by sohel2009 »

I am using a cold fusion cfquery to get data from my vB database.
One of the fields I am trying to get is a date field, and as you know they're unix datetimes.

I am using this and it works great:
<cfquery name="emaillist" datasource="#DSNMySQL#">
SELECT
stuff,
date_format(from_unixtime(vB36_user.joindate),'%M %d %Y') as joindate
FROM
vB36_user
</cfquery>

The output looks like this: January 1 2003.
What I want is January 1, 2003.

How can I get the comma? If I use '%M %d, %Y', it puts the year into a new column.
I could format it the cold fusion page, but that's not how I'm using it, I build a script to download a csv of the data.
Post Reply