Session 01

View All Public Scripts Login to Run Script

Script Name Session 01
Visibility Unlisted - anyone with the share link can access
Description We are using localtimestamp in our jobs to store that value we are using timestamp(9) datatype however while storing value into table we are getting precision up to 6 digits in fraction seconds other three digits are filled with 0. But we need nanoseconds to be stored as well in the table that is 9 digit precision so anyone please help me to get this. PFB the output of the localtimestamp we are using.
Area SQL General / SQL Query
Contributor manoj123lb@gmail.com
Created Thursday July 21, 2022

Statement 1

select localtimestamp(9) from dual


LOCALTIMESTAMP(9)
21-JUL-22 06.38.25.067941 AM

LOCALTIMESTAMP(9)
21-JUL-22 06.38.25.067941 AM

Statement 2

select localtimestamp(9) from dual


LOCALTIMESTAMP(9)
21-JUL-22 06.38.27.017544 AM

LOCALTIMESTAMP(9)
21-JUL-22 06.38.27.017544 AM

Statement 3

select localtimestamp(9) from dual


LOCALTIMESTAMP(9)
21-JUL-22 06.38.39.643580 AM

LOCALTIMESTAMP(9)
21-JUL-22 06.38.39.643580 AM

Additional Information