<< TID (Transaction ID) | IBExpert Glossary | TIMESTAMP >>

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.

See also:
DATE
TIMESTAMP
TIME ZONE
Table Editor
SQL Editor
Data types and subtypes
Selecting the right data type to improve database performance
Firebird 2.5 Language Reference Update
Firebird 2.1 Language Reference Update
Firebird 2.0 Language Reference Update
SQL Language Reference