Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   how to distinct a datetime (http://www.go4expert.com/forums/distinct-datetime-t15172/)

Harrysuke 18Nov2008 13:15

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

pradeep 18Nov2008 18:43

Re: how to distinct a datetime
 
Code: SQL

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



All times are GMT +5.5. The time now is 15:24.