Ramesh Raju Alluri
Reputation: 71
what is difference between from_unixtime vs from_timestamp
Can someone please help to understand basic difference between date format functions available in Impala.
Just to understand
from_unixtime vs from_timestamp
which one is betetter form_unixtime or from_timestap when fetching than a million rows .
Upvotes: 2
Views: 595
Answers (1)
41 72 6c
Reputation: 1780
The Unixtime is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). The converter on this page converts timestamps in seconds, milliseconds and microseconds to readable dates. E.g.
UNIXTIMESTAMP VALUE:
1506285345
TIMESTAMP VALUE:
2017-09-25 01:32:25
Upvotes: 1
Related Questions
- What's the difference between 1/1/1970 and 12/31/1969 UNIX epoch invalid dates?
- Impala built-in function: unix_timestamp function is not accurate enough
- Difference between unix_timestamp and casting to timestamp
- Unix timestamp: everywhere the same?
- python - Difference between two unix timestamps
- timestamps in rails - datetime or UNIX timestamp?
- what timestamp format is it?
- What is the technical difference between the shown time statements
- Unix timestamp question, different times
- Are UNIX_TIMESTAMP() and time() the same