MICROSECOND

Returns the microsecond portion of the specified date as an integer.

Behavior Type

Syntax

MICROSECOND ( date )

Parameters

date

The date to process, one of the following data types:

Example

=> SELECT MICROSECOND (TIMESTAMP 'Sep 22, 2011 12:34:01.123456');
 MICROSECOND
-------------
      123456
(1 row)