Difference between timestamp(0) and timestamp(6)

Question

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

score 18 · Accepted Answer · edited Oct 20 '14 at 21:24

18

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

edited Oct 20 '14 at 21:24

Ben Voigt

277,958
43
419
720

answered Feb 07 '12 at 20:44

Cheery

16,063
42
57

score 4 · Answer 2 · edited Oct 20 '14 at 21:25

4

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

edited Oct 20 '14 at 21:25

Ben Voigt

277,958
43
419
720

answered Feb 07 '12 at 20:45

Foggzie

9,691
1
31
48

Difference between timestamp(0) and timestamp(6)

2 Answers2