1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

how to distinct a datetime

Discussion in 'Visual Basic ( VB )' started by Harrysuke, Nov 18, 2008.

  1. Harrysuke

    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?
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Code:
    SELECT distinct CONVERT(char,myDate,1) from myDataTable
     

Share This Page