drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arjun kr <arjun...@outlook.com>
Subject Re: Illegal Argument Exception while convert unix date format to drill timestamp
Date Thu, 14 Dec 2017 08:17:13 GMT
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 <divya.htconex@gmail.com>
Sent: Thursday, December 14, 2017 9:12 AM
To: user@drill.apache.org
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message