[RESOLVED] Returning DISTINCT Months from Date Field

[Arc]

Hey guys.

I have a table that has a date field in it and i want to return distinct months.

I currently use "SELECT DISTINCT DateAdded FROM tblJobs";

The problem with this is it will return every day of the month..I need it to only return Jan, Feb, Mar etc... Not Jan-01, Jan-02,Jan-03,Mar-05,Mar-09...etc

Any ideas how this can be done?

Thanks!

[bogu]

SELECT DATE_FORMAT("%b-%y",DateAdded) as months FROM tblJobs GROUP BY months

if your DateAdded is a date type field ...

[Arc]

I assume I would also use the Distinct keyword there? I cant have duplicate months at all.

[Arc]

I tried SELECT DISTINCT(DATE_FORMAT("%b-%y",DateAdded) AS NewDate) FROM tblJobs

But that gives errors.

I cant have duplicate months.

Thanks!

[Arc]

I figured it out
SELECT DISTINCT(DATE_FORMAT(DateAdded,'%b-%Y')) as NewDateAdded FROM tblJobs

Thanks!