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…