.Net Articles
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
‹
›
Home
View web version
No comments:
Post a Comment