In our last user group meeting, we discussed lot about DATE
and TIME issues And here I am posting
one link which talks about “Getting the Date portion of a DateTime type in SQL
(T-SQL) - Use Floats and Floor!”. It is worth to read guys…

If we were supposed to write perfect code, debugger wouldn’t have been created.