Skip to Content
1
Oct 27, 2014 at 05:29 PM

CURRENT_TIMESTAMP Microseconds resolution

3413 Views

Hi,

When I try this command from SQL console, I get a resolution till milliseconds (see attached screen).

Do you know if it is possible to increase the resolution till microseconds?

According to the documentation I should be able to get a detail of 7 decimal digits, but after the first three digits all others are 0.

Thanks

Francesco

SELECT TO_VARCHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF7') "to timestamp" FROM DUMMY