There is a simple update statement that I can perform to update a date, time, minute, and seconds field in a firebird to remove part of milliseconds.
then the current value is: 10/03/2017 17: 30: 51.3560 I want to update it to be: 10/03/2018 17: 30: 51.0000 .
I need a generic update statement that computes the new date and time record based on the old timestamp
.