Saturday, 22 February 2014

TIME STAMP(0) and TIMESTAMP(6) in Teradata?

What is the difference between TIMESTAMP (0) and TIMESTAMP (6) in teradata?


Both has the Date and Time Values. The major difference is that TIMESTAMP (6) has microsecond too.

Output:  TIMESTAMP(0)=12:00
               TIMESTAMP(6)=12:00:00

No comments:

Post a Comment