1. 

   Harrysuke New Member

   Joined:

   Nov 18, 2008

   Messages:

   1

   Likes Received:

   0

   Trophy Points:

   0

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

    

   Harrysuke, Nov 18, 2008

   SHARE #1
2. 

   pradeep Team Leader

   Joined:

   Apr 4, 2005

   Messages:

   1,645

   Likes Received:

   87

   Trophy Points:

   48

   Occupation:

   Programmer

   Location:

   Kolkata, India

   Home Page:

   http://blog.pradeep.net.in

   Code:

   SELECT distinct CONVERT(char,myDate,1) from myDataTable

    

   pradeep, Nov 18, 2008

   SHARE #2

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in