FROM_UNIXTIME_WITHUNIT

​

Syntax

​

Scalar

from_unixtime_withunit(value, unit)

​

Arguments

​

Returns

• Type: TIMESTAMP with UTC timezone
• NULL behavior: NULL value yields NULL. NULL/unknown unit raises an error; non-finite input or overflow raises an error.

​

Properties

​

Units

• Input unit: Epoch seconds or milliseconds UTC
• Output unit: Microsecond UTC timestamp
• Seconds * 1000000; milliseconds * 1000.

​

Usage notes

• Second aliases: SECOND, SECONDS, SEC, SECS, S. Millisecond aliases: MILLISECOND, MILLISECONDS, MILLI, MILLIS, MS, MSEC.
• Unit matching trims whitespace and ignores case.
• Floats truncate converted microseconds toward zero; decimals round halfway away from zero.

​

Examples

​

Basic example

SELECT from_unixtime_withunit(1500,'MILLISECONDS') AS result;

​

Equivalent inputs in different units

SELECT from_unixtime_withunit(1, 'SECONDS') AS from_seconds, from_unixtime_withunit(1000, 'MILLISECONDS') AS from_milliseconds;

​

Related functions

• from_unixtime