Declares a time value in an expression.
Syntax
TIME 'string'
Syntax Elements
- string
- 8- to 21-character string in one of these formats:
Format Description hh:mi:ss Time with no fractional seconds digits or Time Zone: - hh represents the hour of the day. The valid range is 00–23, inclusive. You must specify both digits.
- mi represents minute of the hour. The valid range is 00–59, inclusive. You must specify both digits.
- ss represents seconds. The valid range is 00–61. You must specify both digits.
hh:mi:sssignhh:mi Time with a specified Time Zone, but no fractional seconds digits: - hh represents the hour of the day. The valid range is 00–23, inclusive. You must specify both digits.
- mi represents minute of the hour. The valid range is 00–59, inclusive. You must specify both digits.
- ss represents seconds. The valid range is 00–61. You must specify both digits.
- signhh:mi represents the hours and minutes in the Time Zone offset. The valid range is -12:59 through +13:00, inclusive.
hh:mi:ss.ssssss Time with up to six fractional seconds digits, but no Time Zone: - hh represents the hour of the day. The valid range is 00–23, inclusive. You must specify both digits.
- mi represents minute of the hour. The valid range is 00–59, inclusive. You must specify both digits.
- ss.ssssss represents seconds. The valid range for the first two digits is 00–61. You must specify both digits. You can specify from one to six fractional digits.
hh:mi:ss.sssssssignhh:mi Time with up to six fractional seconds and a Time Zone offset: - hh represents the hour of the day. The valid range is 00–23, inclusive. You must specify both digits.
- mi represents minute of the hour. The valid range is 00–59, inclusive. You must specify both digits.
- ss.ssssss represents seconds. The valid range for the first two digits is 00–61. You must specify both digits. You can specify from one to six fractional digits.
- signhh:mi represents the hours and minutes in the Time Zone offset. The valid range is -12:59 through +13:00, inclusive.
Example 1: hh:mi:ss Format
The following example selects all classes from the Classes table that start at 3:30 PM.
SELECT * FROM Classes WHERE start_time = TIME '15:30:00';
Example 2: hh:mi:sssignhh:mi Format
SELECT * FROM Classes WHERE start_time = TIME '10:37:12-08:00';
Example 3: hh:mi:ss.ssssss Format
SELECT * FROM Classes WHERE start_time = TIME '10:36:02.123456';
Example 4: hh:mi:ss.sssssssignhh:mi Format
SELECT Customer_ID FROM Messages WHERE start_time = TIME '21:17:35.123456+07:30'
Related Information
FOR information on … | SEE … |
---|---|
TIME data types | TIME Data Type. |
TIME WITH TIME ZONE data types | TIME WITH TIME ZONE Data Type. |