Re: Illegal Argument Exception while convert unix date format to drill timestamp

Hi Divya, Default timestamp format for Drill is '-MM-DD HH:MI:SS'. For the cases, when you want to get a timestamp from a string with another format, date pattern should be specified. Drill allows using both Jodatime patterns (to_date, to_time, to_timestamp functions, see allowed patterns at

Re: Illegal Argument Exception while convert unix date format to drill timestamp

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 ') FROM (VALUES(1)); ++ | EXPR$0 | ++ | 2018-04-01 00:00:01.0 | ++ 1 row