[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