Why Timestamp(6) precision only upto 2 fractional seconds?

Database
N/A

Why Timestamp(6) precision only upto 2 fractional seconds?

Hi,

We have Teradata 12 on Linux SLES10 - SP1

When i run the command (several times, for comparision and i removed the timezone info from results):

select current_timestamp(6);

2012-02-21 08:52:00.150000

2012-02-21 08:52:29.600000

2012-02-21 08:52:46.260000

2012-02-21 08:54:24.440000

Why is the precision only upto 0.01 seconds even though we requested for upto 6 fractional digits of second?

Is it a limitation at the OS level or Teradata db?

Is there a way to increase the precision to 6 places and if we do is there a performance hit?

Thanks,

-srinivas yelamanchili

Tags (2)
2 REPLIES
N/A

Re: Why Timestamp(6) precision only upto 2 fractional seconds?

Hi,

this is from the TD manual - SQL->functions&


"Precision


The seconds precision of the result of CURRENT_TIMESTAMP is limited to hundredths of a


second. CURRENT_TIMESTAMP returns zeros for any digits to the right of the two most


significant digits in the fractional portion of seconds.


"


You can load more precise data from external source but you can't generate more with the current_timestamp function.

N/A

Re: Why Timestamp(6) precision only upto 2 fractional seconds?

Thanks Ulrich, that answers the mystery !!!