datepart in SELECT statement

Results 1 to 2 of 2

Thread: datepart in SELECT statement

  1. #1
    Join Date
    Dec 1969

    Default datepart in SELECT statement

    Okay, what is the corect verbage for trying to select a distinct recordset of months. I want a list box to display all the distinct Months in a table.<BR><BR>Below is what I have:<BR>MonthSQL = "SELECT DISTINCT start FROM dtlc;"<BR><BR>"Start" is the name of a datetime field. I want to pull out and select the DISTINCT month portion only. Any clues, hints or bones on this one?<BR><BR>-ferretworks

  2. #2
    Join Date
    Dec 1969

    Default SELECT DISTINCT datepart(mm,start) FROM dtlc <


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts