TIME

The format in which TIME values are retrieved as strings by applications is controlled by the time_format creation parameter. For example, the TIME value 23:59:59.999999 can be returned to an application as 23:59:59, 23:59:59.999, or 23:59:59.999999 depending on the time_format creation parameter.

A TIME value requires 8 bytes of storage.

• Time formats
• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• CURRENT UTC TIMESTAMP special value
• UltraLite date and time functions
• DATE data type
• DATETIME data type
• DATE function [Date and time]
• DATETIME function [Date and time]
• Expressions in UltraLite
• GETDATE function [Date and time]
• ISDATE function [Data type conversion]
• NOW function [Date and time]
• TIMESTAMP data type
• TIMESTAMP WITH TIME ZONE data type
• UltraLite timestamp_format creation parameter
• UltraLite Java edition timestamp_format option
• UltraLite timestamp_with_time_zone_format creation parameter
• UltraLite Java edition timestamp_with_time_zone_format option