...
Timestamps are interpreted to be timezoneless and stored as an offset from the UNIX epoch. Convenience UDFs for conversion to and from timezones are provided (to_utc_timestamp
, from_utc_timestamp
).
All existing datetime UDFs (month, day, year, hour, etc.) work with the TIMESTAMP
data type.
Timestamp in text format files have to comply with format yyyy-mm-dd hh:mm:ss.f.... If they are in another format declare them as an INT, FLOAT or STRING type if they are in the format conversion format listed above, and cast them.
Info | ||
---|---|---|
| ||
Timestamps were introduced in Hive 0.8.0 (HIVE-2272). |
...