MICROSECOND: Obtaining Microseconds From Time/Timestamp

How to:

The MICROSECOND function returns the number of microseconds from a time or timestamp value.


Top of page

x
Syntax: How to Obtain the Number of Microseconds From a Time or Timestamp
MICROSECOND(arg)

where:

arg

Time or timestamp

Is the input value.

This function returns an integer value.



Example: Obtaining the Number of Microseconds From a Time or Timestamp

MICROSECOND returns the microseconds from a time or timestamp. This example,

MICROSECOND('11:22:33.456789')

returns 456,789.

This example,

MICROSECOND('2001-01-22 10:00:00')

returns 0.


iWay Software