Database Reference
In-Depth Information
statement. The resolution of the time portion of a
TIMESTAMP
value is in
nanoseconds.
As
TIMESTAMP
values are time-specific values, they are not stored using
the local time zone; instead, all timestamps in Impala are stored relative to
GMT.
Impala automatically converts
STRING
values of the correct format into
TIMESTAMP
values if they are written in any supported time format string.
For example, 1980-12-21 or 2001-01-01 05:05:50 can be converted to
TIMESTAMP
values.
Casting an integer or floating-point value N to
TIMESTAMP
produces a value,
which is N seconds past the start of the epoch date (January 1, 1970).
Now, we are going to learn about how to use operators with Impala SQL statements.