[thelist] CF & SQL: Selecting unique months from date column

Tab Alleman Tab.Alleman at MetroGuide.com
Wed Jul 16 12:09:46 CDT 2003

Minh Lee Goon wrote:

> Does anyone have a CF or SQL way of selecting only individual months
> in a column? I'd really appreciate any help. Thanks.

SELECT Month(DateColumn)
FROM TableName
GROUP BY Month(DateColumn)

More information about the thelist mailing list