> On Jun 2, 2021, at 1:56 PM, Micah Kornfield <[email protected]> wrote: > > > At least in bigquery we do the following mapping: > SQL TIMESTAMP -> Arrow Timestamp with "UTC" timezone > SQL DATETIME -> Arrow Timestamp without a time-zone.
BigQuery was one of the systems I had in mind when I said "naming is a little inconsistent". BigQuery does have a type consistent with SQL-standard TIMESTAMP type but it’s called DATETIME. The TIMESTAMP type is something else. I can literally count the number of hours and dollars that have been wasted because my colleagues assumed that BigQuery’s TIMESTAMP type would have the same semantics as TIMESTAMP in other databases. Julian
