description |
---|
Converts the input expressions to the corresponding time. |
- numeric_expression: A Unix epoch timestamp.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME(1665131223)
-- 08:27:03
{% endcode %}
- numeric_expression: A Unix epoch timestamp.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME(1665131223)
-- 08:27:03
{% endcode %}
- string_expression: The string from which to extract the time.
- format: String to specify format of the time.
- replaceErrorWithNull: If 0, the function will fail when given malformed input. If 1, the function will return NULL when given malformed input.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME('09:15:00.23232', 'HH:MI:SS', 1)
-- NULL
{% endcode %}
- string_expression: The string from which to extract the time.
- format: String to specify format of the time.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME('09:15:00', 'HH:MI:SS')
-- 09:15:00
{% endcode %}
- numeric_expression: A Unix epoch timestamp.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME(1665131223.69)
-- 08:27:03
{% endcode %}
- numeric_expression: A Unix epoch timestamp.
Examples
{% code title="TO_TIME example" %}
SELECT TO_TIME(1665131223.69)
-- 08:27:03
{% endcode %}