Navigation:  »No topics above this level«

FRAC_SECOND()

Advantage Concepts

Return to chapter overview

Scalar function that retrieves the milliseconds part of a timestamp.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

FRAC_SECOND( <tTime> ) à nMilliseconds

Parameters

<tTime>

A time or timestamp value

Return Value

Integer millisecond from the given timestamp.

See Also

YEAR()

QUARTER()

MONTH()

WEEK()

DAY()

HOUR()

MINUTE()

SECOND()

EXTRACT()