All Forums Database
ysrinu 44 posts Joined 04/07
21 Feb 2012
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

 

 

ulrich 816 posts Joined 09/09
21 Feb 2012

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

ysrinu 44 posts Joined 04/07
21 Feb 2012

Thanks Ulrich, that answers the mystery !!!

You must sign in to leave a comment.