How to get date from datetime in sql
  • hi i have datetime column in sql but when i select it show like "2011-08-01 00:00:00.000" but i want to just fetch "2011-08-01" how can i do it?
  • 1 Comment sorted by
  • Vote Up0Vote Down itworkeritworker
    38.50 Karma Accepted Answer
    Hi use this.

    select convert(varchar(10), ColumnName, 120) from TableName

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Optimum Creative