MICROSECOND
Returns the microsecond portion of the specified date as an integer.
Behavior Type
- Immutable if the
specified date is a
TIMESTAMP
,INTERVAL
, orVARCHAR
- Stable if the specified date is a
TIMESTAMPTZ
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)