date time to date only

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kkshansid
    New Member
    • Oct 2008
    • 232
    #1

    date time to date only

    how to convert my fiield project date which is giving date and time both to give only date
    my query is
    select [project date] from project
    it gives
    project date

    2003-05-08 00:00:00
    i want
    2003-05-08
    format
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Use CONVERT() function.

      Happy Coding!

      -- CK

        Comment

        Previous template Next
        Working...