microsoft sql server management studio

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cherychoclatecandy
    New Member
    • May 2008
    • 10

    microsoft sql server management studio

    How to change a datetime column to date format only using microsoft sql server management studio?


    eg
    5/2/2008 8:49:48 AM to date format only (5/2/2008)
  • balame2004
    New Member
    • Mar 2008
    • 142

    #2
    Open table in design view, select column that you want to format and use format field that is shown in the bottom of the design window.

    Comment

    Working...