1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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