Menu
Can some body tell me the difference between timestamp(0) and timestamp(6) in Teradata
751
A TIMESTAMP can store up to 9 digits of fractional seconds. You can also declare a TIMESTAMP WITH TIME ZONE or a TIMESTAMP WITH LOCAL TIME ZONE that stores a time zone as well so that you can convert times from one time zone to another.
By default format of TIMESTAMP is 'YYYY-MM-DD HH24:MI:SS. FF'. By default format of TIMESTAMP WITH TIME ZONE is 'YYYY-MM-DD HH24: MI: SS. FF TZH: TZM'.
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.
163
The number (0 or 6) is the number of digits for fractions of a second that you want to store. 6 is the maximum.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
