nanosecond
Syntax
nanosecond(X)
Arguments
X is a scalar/vector of type TIME, TIMESTAMP, NANOTIME or NANOTIMESTAMP.
Details
For each element in X, return a number indicating which nanosecond of the second it falls in.
Examples
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