Difference between timestamp(0) and timestamp(6)

timestamp teradata
user1172117 picture user1172117 · Feb 7, 2012 · Viewed 24.4k times · Source

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

Answer

Cheery picture Cheery · Feb 7, 2012

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.

Related questions

How do you get a timestamp in JavaScript?

How can I get a timestamp in JavaScript? Something similar to Unix timestamp, that is, a single number that represents the current time and date. Either as a number or a string.

Read More
NOW() function in PHP

Is there a PHP function that returns the date and time in the same format as the MySQL function NOW()? I know how to do it using date(), but I am asking if there is a function only for this. …

Read More
Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the server side.

Read More