Monday, June 08, 2009 11:09 AM
Apparently, converting a SQL long datetime string to just a date seems to be a head banger for some people. therefore, I’ve decided to publish the way I do it, which I believe is easy and probably the most efficient.
convert(varchar(10),[datetimecolumnname],101)
replace [datetimecolumnname] with the column name of the actual column that is of datetime data type.