Example: Truncating Digits in Fractional Seconds - Teradata Vantage - Analytics Database

This is an example of truncating digits in fractional seconds according to the requested format of FF[1..9] for milliseconds in the timestamp value:

select to_char(timestamp '2020-09-01 23:45:09.999999','yyyy-mm-dd hh:mi:ss.FF1');

The result is:

to_char(2020-09-01 23:45:09.999999,'yyyy-mm-dd hh:mi:ss.FF1')
-------------------------------------------------------------
2020-09-01 11:45:09.9