15.4.7 nanosecond(value1)

Extracts and returns the current fractional part of second from date.

Value 1 can be one of the following types: timestamp.

Returned value will be of type big integer.

Function Result

nanosecond(transaction_time), 12/19/2016 12:22:57

719978080