GitHub

[C++][Arrow Flight SQL ODBC] timestamp conversion from non-UTC to UTC

the current behavior of ODBC is that it ignores the time zone field in Timestamp data, assumes all timestamp data is UTC during interpretation. The Arrow compute ...
GitHub

Time format for Spark to Presto conversion of unix_timestamp not inclusive of microseconds

SELECT TO_UNIXTIME(COALESCE(TRY(DATE_PARSE(CAST(mytime AS VARCHAR), '%Y-%m-%d %T')), PARSE_DATETIME(CAST(mytime AS VARCHAR), 'yyyy-MM-dd HH:mm:ss'))) FROM table1 ...