Returns current date and time

SELECT 
    SYSDATE()

We can pass parameter

precision

to the function that indicates milliseconds and microseconds:

SELECT 
    SYSDATE(6)

Maximum

precision

is 6, if we pass more than the supported number, we will get an error

SELECT 
    SYSDATE(7)

After running the query, the following error will be generated:

#1426 - Too big precision 7 specified for 'sysdate'. Maximum is 6