CURRENT_TIMESTAMP Microseconds resolution

[francesco_alborghetti]

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

[former_member204338]

the question is still open.

[lbreddemann]

As this question has been marked as answered it would be best to create a new question with what you want to know.