Hi,
I hope Solution1 will help you understand DateTime in SQL Server
In addition to that solution you can see
this [
^]to dig further... I already bookmarked this for my convenience since ;-)
You can also book mark this to improve your productivity.
Hope this helps you a bit.
Regards,
RK