microsecond()

Scalar. Returns an integer representing the microsecond extracted from a given bigdatetime.

Syntax

microsecond ( bigdatetime [ ,timezone ] )

Parameters

bigdatetime

A bigdatetime value.

timezone

(Optional) A string representing the time zone. If none is specified, UTC is used. See 'Time Zones" and "List of Time Zones" for more information.

Usage

Returns an integer representing the microsecond extracted from a given bigdatetime. The function takes a bigdatetime as its argument (and an optional string representing a time zone), and the function returns an integer.

Example

microsecond ((unbigdatetime ('2010-03-03 12:34:34:059111')) returns 059111.