how to distinct a datetime

Harrysuke

can i know how to distinct datetime in sql so that i can populate my combo1.additem from January to December?

pradeep

Code: SQL

SELECT DISTINCT CONVERT(char,myDate,1) FROM myDataTable

Harrysuke Newbie Member
18Nov2008,13:15	#1
	can i know how to distinct datetime in sql so that i can populate my combo1.additem from January to December?

pradeep Team Leader
18Nov2008,18:43	#2
	Code: SQL SELECT DISTINCT CONVERT(char,myDate,1) FROM myDataTable

Already a member?

User Name:		Save
Password