nanosecond

nanosecond(X)

X is a scalar/vector of type TIME, TIMESTAMP, NANOTIME or NANOTIMESTAMP.

For each element in X, return a number from 0 to 999999999 indicating which nanosecond of the second it falls in.

nanosecond(13:30:10.008);
// output
8000000

nanosecond([2012.12.03 01:22:01.999999999, 2012.12.03 01:25:08.000000234]);
// output
[999999999,234]

Related functions: dayOfYear, dayOfMonth, quarterOfYear, monthOfYear, weekOfYear, hourOfDay, minuteOfHour, secondOfMinute, millisecond, microsecond