Pls see if this works for you.
0: jdbc:drill:schema=dfs> SELECT TO_TIMESTAMP('Sun Apr 1 00:00:01 UTC 2018', 'E
MMM d HH:mm:ss z yyyy') FROM (VALUES(1));
+------------------------+
| EXPR$0 |
+------------------------+
| 2018-04-01 00:00:01.0 |
+------------------------+
1 row selected (0.165 seconds)
0: jdbc:drill:schema=dfs>
Thanks,
Arjun kr
________________________________
From: Divya Gehlot <[email protected]>
Sent: Thursday, December 14, 2017 9:12 AM
To: [email protected]
Subject: Illegal Argument Exception while convert unix date format to drill
timestamp
Hi,
Does Drill supprts to convert Unix date format to Drill timstamp ?
Unix TimeStamp : Thu Dec 14 03:40:50 UTC 2017
When I Cast to Drill time stamp I get Illegal Argument Exception.
Thanks,
Divya
