Which hook to use when a date is going to be saved into the database
If you are only using nodes then yes, implementing hook_node_update is a good approach. You also will need to implement hook_node_insert if you need to do logic when the nodes are first created.