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 from 0 to 999999999 indicating which nanosecond of the second it falls in.

Examples

$ nanosecond(13:30:10.008);
8000000

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

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