Can use unix_timestamp, challenge is that Drill timestamp has millisec that causes issues. SO you can truncate the millisec.
I.e. select to_timestamp(1432912733), unix_timestamp(substr(to_timestamp(1432912733),1,19)) from `sys`.`version`; +------------------------+-------------+ | EXPR$0 | EXPR$1 | +------------------------+-------------+ | 2015-05-29 15:18:53.0 | 1432912733 | +------------------------+——————+ If you don’t truncate the millsec it causes an error. Perhaps there is another function that can handle millisec and not require the string function. select to_timestamp(1432912733), unix_timestamp(to_timestamp(1432912733)) from `sys`.`version`; Error: SYSTEM ERROR: java.lang.IllegalArgumentException: Invalid format: "2015-05-29 15:18:53.000" is malformed at ".000” —Andries On Jun 15, 2015, at 7:18 AM, Christopher Matta <[email protected]> wrote: > Is there a way to convert a timestamp string to unix time? > > Chris Matta > [email protected] > 215-701-3146
