All geek questions in one place

Difference between timestamp (0) and timestamp (6)

Can any body tell me the difference between a timestamp (0) and a timestamp (6) in Teradata p>

+6
source share
2 answers

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

+13
source

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

+3
source

Source: https://habr.com/ru/post/907878/

More articles:


All Articles