how to distinct a datetime

Harrysuke's Avatar, Join Date: Nov 2008
Newbie Member
can i know how to distinct datetime in sql so that i can populate my combo1.additem from January to December?
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Code: SQL
SELECT DISTINCT CONVERT(char,myDate,1) FROM myDataTable