Difference between timestamp(0) and timestamp(6)

Question

Can some body tell me the difference between timestamp(0) and timestamp(6) in Teradata

Solution 1

timestamp(p), where p is the number of digits in the fractional part of second (microseconds), 0 ⇐ p ⇐ 6. With 0 there are no fractions of the second.

• TIMESTAMP documentation on official Teradata site

Solution 2

The number (0 or 6) is the number of digits for fractions of a second that you want to store. 6 is the maximum.

• TIMESTAMP documentation on official Teradata site