Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
3.1.2
Description
Description -
unix_timestamp() accept 4 value string/date/timestamp/timestamptz. Out of which date/timestamp/timestamptz use DateTimeFormatter.class where as string type use SimpleDateTimeformatter.class which cause difference is value.
Example -
select from_unixtime(unix_timestamp('1800-11-08 01:53:11'));
1800-11-08 01:35:15
select from_unixtime(unix_timestamp(cast('1800-11-08 01:53:11' as timestamp)));
1800-11-08 01:53:11
Attachments
Issue Links
- causes
-
HIVE-25577 unix_timestamp() is ignoring the time zone value
- Closed
- is duplicated by
-
HIVE-25499 select unix_timestamp(dt) from table and select unix_timestamp(constant date) are different
- Resolved
- is related to
-
HIVE-25576 Configurable datetime formatter for unix_timestamp, from_unixtime
- Closed
- links to