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.
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.
CURRENT_TIMESTAMP precision is limited to hundreths (two digits after the point).
If you need more precission you could go for an UDF.