Extract date from datetime in sql
{ Posted on 1/03/2010 03:49:00 PM
by Silvercode
}
Tags :
SQL SERVER
How do we extract date part from datetime in sql???
below is the query to do that....
select convert(varchar(10), '10/21/2009 23:15:0000',110)
it returns the resultset as:
10/21/2009
below is the query to do that....
select convert(varchar(10), '10/21/2009 23:15:0000',110)
it returns the resultset as:
10/21/2009
No Response to "Extract date from datetime in sql"
Post a Comment