The Time Data Type is used to represent the time of the day. The time consists of an hour, minute, second, and millisecond, all of which begin at zero.

Structure

Time is an object with the following properties:

• hour (number) - an hour of a day represented by a 24-hour clock
• minute (number) - the number of minutes into the hour
• second (number) - the number of seconds into the minute
• millisecond (number) - the number of milliseconds into the second

Examples

Let's assume we have an example_time variable holding the following time:

time: {  
    "hour": 12,  
    "minute": 00,  
    "second": 00,  
    "millisecond": 000  
}

We can use the TIME function, which takes the hour, the minute, the second and, optionally, the millisecond, for example, to create a time representing exactly noon:

example_time = TIME(12, 00, 00, 000) -> {  
    "hour": 12,  
    "minute": 00,  
    "second": 00,  
    "millisecond": 000  
}

Also, we can use the FORMAT_TIME function to format the time into the string "12 pm":

FORMAT_TIME(  
  example_time,   
  "h:mm a"
) -> "12:00 PM"