> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MAKE_TIME

> Constructs a time with fractional-second precision.

<div className="e6-meta"><span className="e6-eyebrow e6-eyebrow--quiet">Scalar function</span></div>

Any NULL component yields NULL. Non-finite seconds and out-of-range components raise an error.

## Syntax

### Scalar

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
make_time(hour, minute, second)
```

## Arguments

| Name | Type | Required | Description |
| - | - | - | - |
| hour | TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE or DECIMAL(p, s) | Yes | Hour, coerced to INTEGER, 0..23. For DECIMAL(p, s), p is precision (total digits) and s is scale (digits after the decimal point). |
| minute | TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE or DECIMAL(p, s) | Yes | Minute, coerced to INTEGER, 0..59. For DECIMAL(p, s), p is precision (total digits) and s is scale (digits after the decimal point). |
| second | TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE or DECIMAL(p, s) | Yes | Second, coerced to DOUBLE, 0 \<= value \< 60. For DECIMAL(p, s), p is precision (total digits) and s is scale (digits after the decimal point). |

## Returns

* Type: TIME with microsecond precision
* NULL behavior: Any NULL component yields NULL. Non-finite seconds and out-of-range components raise an error.

## Properties

| Property | Value |
| - | - |
| Deterministic | Yes |
| Exact result | Yes |

## Usage notes

* Fractional seconds round to the nearest microsecond.
* Hour/minute are converted to INTEGER; second retains a DOUBLE fractional component.
* A sub-60 second value rounding to 60 seconds is clamped to 59.999999 seconds.
* INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.

## Examples

### Basic example

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT make_time(10,30,45.5) AS result;
```

| result |
| - |
| 10:30:45.500000 |

### Midnight and fractional seconds

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT make_time(0, 0, 0) AS midnight, make_time(23, 59, 59.25) AS late_time;
```

| midnight | late\_time |
| - | - |
| 00:00:00 | 23:59:59.250000 |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.