All Forums Database
ysrinu 44 posts Joined 04/07
21 Feb 2012
Why Timestamp(6) precision only upto 2 fractional seconds?


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?



-srinivas yelamanchili



ulrich 816 posts Joined 09/09
21 Feb 2012


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




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.