DateTime Value

How to Update Date or Time in EXCEL

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

To update/extract the date or Time part separately in a DateTime Value is a lot easier  if you understand that excel stores dates as sequential serial numbers and time as a fractional portion of a 24 hour day. With the above understanding, you can combine INT and MOD functions to perform calculations on or extract the […]

datetime image

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 […]