How to Update Only Date or Time Portion of DateTime Value in SQL

Crispo Mwangi | 17-Jun-16 | Leave a Comment

Updating/Modifying date or time portion separately in a DateTime value can be a toothache in SQL. The following is a simple procedure on how to do it. In SQL Server use the DATEADD functions to easily perform calculations such as adding or subtracting days or Hours in a DateTime value. For example if you have […]