TIME

The TIME data type is new to InterBase® v 6.0. It is an SQL dialect 3 data type. TIME is a 32-bit field type of TIME values. The range is from 0:00 AM to 23:59:9999 PM.

It is possible to specify the display format of a date field under Environment Options / Grid / Display Formats. For the various options available, please refer to Date Time Format.

New to Firebird 4.0: Time zone support consists of TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE data types, expressions and statements to work with time zones and conversion between data types without/with time zones. Please refer to TIME ZONE for details.