SELECT
CAST ('2022-02-01' AS DATE) AS date,
source,
medium,
conversions,
revenue
FROM
`united-strategy-279207.new_dataset.table_test_5`
SELECT
CAST(date_0 AS DATE) AS date_0
FROM (
SELECT
'05.03.22' AS date_0
) AS table_1
SELECT
safe_CAST(date_0 AS DATE) AS date_0
FROM (
SELECT
'05.03.22' AS date_0
) AS table_1
SELECT
safe_CAST(date_0 AS DATE) AS date_0,
safe_CAST(date_1 AS DATE) AS date_1,
safe_CAST(date_2 AS DATE) AS date_2,
FORMAT_DATE('%b %d,%Y', safe_CAST(date_1 AS DATE)) AS new_format_date_1
FROM
(
SELECT
'05.03.22' AS date_0,
'2022-05-07' AS date_1,
'01-05-2022' AS date_2
) AS table_1
SELECT
PARSE_DATE('%m.%d.%Y', '05.03.2020') as date_0
SELECT
CAST(CONCAT(REGEXP_EXTRACT(date_0, r'\/([0-9]{4})'), "-",
REGEXP_EXTRACT(date_0, r'([0-9]{1,2})\/'), "-",
REGEXP_EXTRACT(date_0, r'\/([0-9]{1,2})\/')) AS DATE) AS from_str_to_date
FROM (
SELECT
'10/07/2022' AS date_0 ) AS table_1
SELECT
CAST('2022-07-07 10:02:01' AS DATETIME) AS datetime
SELECT
CAST('2022-07-13 05:05:11-8:00' AS TIMESTAMP) AS timestamp