[DRILL-758] to_timestamp(unix time) not returning correct result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 16/May/14 15:13
• Updated: 15/Mar/17 16:08
• Resolved: 06/Jun/14 03:01

Description

Ran the following to_timestamp query passing it a unix timestamp:

select to_timestamp(1284352323) from voter where voter_id=10;

The value returned looks like unix epoch time:
1970-01-15T20:45:52.323-08:00

Any unix time used returned the same year (1970) and month (01).