Lately, I had to deal with a timestamp value with an overly long sequence of decimal digits, coming as a string in ISO 8601 format : 1970-01-04T15:20:34.49899986153468675 The goal was to build an Oracle TIMESTAMP instance from this lexical representation, but rounded to 3 decimal places : 1970-01-04 15:20:34.499 In SQL, when we already have … Continue reading Rounding Timestamp Values with Fractional Seconds
