Returned Data Types And Ranges

Procedural SQL (PSQL) StatementsAggregate Functions

Returned Data Types and Ranges

The returned data types and possible ranges are shown in the table below.If you try to extract a part that isn’t present in the date/time argument (e.g. SECOND from a DATE or YEAR from a TIME), an error occurs.

Table 1. Types and ranges of `EXTRACT` results
Part	Type	Range	Comment
`YEAR`	`SMALLINT`	1-9999
`MONTH`	`SMALLINT`	1-12
`QUARTER`	`SMALLINT`	1-4
`WEEK`	`SMALLINT`	1-53
`DAY`	`SMALLINT`	1-31
`WEEKDAY`	`SMALLINT`	0-6	0 = Sunday
`YEARDAY`	`SMALLINT`	0-365	0 = January 1
`HOUR`	`SMALLINT`	0-23
`MINUTE`	`SMALLINT`	0-59
`SECOND`	`NUMERIC(9,4)`	0.0000-59.9999	includes millisecond as fraction
`MILLISECOND`	`NUMERIC(9,1)`	0.0-999.9
`TIMEZONE_HOUR`	`SMALLINT`	-23 - +23
`TIMEZONE_MINUTE`	`SMALLINT`	-59 - +59

`MILLISECOND`

Extracts the millisecond value from a TIME or TIMESTAMP.The data type returned is NUMERIC(9,1).

Note	If you extract the millisecond from [fblangref50-contextvars-current-time], be aware that this variable defaults to seconds precision, so the result will always be 0.Extract from `CURRENT_TIME(3)` or [fblangref50-contextvars-current-timestamp] to get milliseconds precision.