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

Calculate time difference in Teradata

I have a scenario to calculate difference of timestamp in minute. There is one common field in 2 tables i.e dw_job_id and want to join 2 tables and guessing, calculate (scratch.COGIPF_RUNREPORT_test2.end_ts - concat(proct_…

Read More
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