how to get the current_timestamp value in micro format like 11/08/2015 12:22:09.754321

Database
Teradata Employee

how to get the current_timestamp value in micro format like 11/08/2015 12:22:09.754321

Hi All,

when we execute below SQL statment we get output like 11/08/2015 12:22:09.750000. Evn our table Timestamp column have this format value.

Sel Current_timestamp;

we want out in micro format like 11/08/2015 12:22:09.754321. But we are getting these bold values zero only. We get highlight four digit after decimal only zero . Is there any way to get all six digit after decimal non-zero. Is there any DBS setting to change or any way to get this output.

1 REPLY
Junior Supporter

Re: how to get the current_timestamp value in micro format like 11/08/2015 12:22:09.754321

Hi.

CURRENT_TIMESTAMP precision is limited to hundreths (two digits after the point).

If you need more precission you could go for an UDF.

HTH.

Cheers.

Carlos.