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):
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?
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.