Amazon Redshift to BigQuery SQL translation reference

TIMESTAMP STRING literal (e.g. "2008-12-25T07:30:00") DATETIME STRING literal (e.g. "15:30:00”) TIME Explicit conversion types You can convert Redshift data types that BigQuery doesn’t implicitly convert using BigQuery’s C AST(expression AS type) function or any of the D ATE and T IMESTAMP ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.