I have a timestamp column on an 11g DB which, due to a coding error which has since been fixed, caused the minute, second, millisecond... to be included instead of just "00". For example,
10/7/2018 02:03:02.432000 AM
What I need is to update all of these records which have a minute, second, millisecond greater than "00" to be "00"
e.g. 10/7/2018 02:00:00.000000 AM
I've played around with the extract() function, but I just can't figure out the correct syntax.