January 3, 2010

Extract date from datetime in sql

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

No comments:

Post a Comment