SQL
Time Functions
The table below shows the available scalar functions for `TIME` types.  
| Name | Description |
|:--|:-------|
| [`current_time`](#::current_time) | Current time (start of current transaction). |
| [`date_diff(part, starttime, endtime)`](#::date_diffpart-starttime-endtime) | The number of [partition](#docs:sql:functions:datepart) boundaries between the times. |
| [`date_part(part, time)`](#::date_partpart-time) | Get [subfield](#docs:sql:functions:datepart) (equivalent to `extract`). |
| [`date_sub(part, starttime, endtime)`](#::date_subpart-starttime-endtime) | The number of complete [partitions](#docs:sql:functions:datepart) between the times. |
| [`datediff(part, starttime, endtime)`](#::datediffpart-starttime-endtime) | Alias of `date_diff`. The number of [partition](#docs:sql:functions:datepart) boundaries between the times. |
| [`datepart(part, time)`](#::datepartpart-time) | Alias of date_part. Get [subfield](#docs:sql:functions:datepart) (equivalent to `extract`). |
| [`datesub(part, starttime, endtime)`](#::datesubpart-starttime-endtime) | Alias of date_sub. The number of complete [partitions](#docs:sql:functions:datepart) between the times. |
| [`extract(part FROM time)`](#::extractpart-from-time) | Get subfield from a time. |
| [`get_current_time()`](#::get_current_time) | Current time (start of current transaction). |
| [`make_time(bigint, bigint, double)`](#::make_timebigint-bigint-double) | The time for the given parts. |  
The only [date parts](#docs:sql:functions:datepart) that are defined for times are `epoch`, `hours`, `minutes`, `seconds`, `milliseconds` and `microseconds`.