How do I update a firebird date, time, minute, and seconds field by removing part of milliseconds?

0

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 .

    
asked by anonymous 03.10.2018 / 22:32

0 answers