There are a lot of goodies embedded in the framework, problem is, there are so many namespaces that it is almost impossible to know them all, as a matter of fact I doubt that there is any one person that knows all of the framework in and out. As usual, this post is about my experience with weird code that could have been done easily using existing built functions. I’ve seen developers write 20+ lines of code to this stuff while covering every possible scenario. convert to absolute System.Web.VirtualPathUtility.ToAbsolute(params);
...
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.