例如:
SELECT
DATE_SUB(
subdate(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
date_format(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
'%w'
) - 1
),
INTERVAL 1 WEEK
) AS week_start,
subdate(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
date_format(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
'%w'
) - 1
) AS etl_week_end
SELECT
DATE_SUB(
subdate(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
date_format(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
'%w'
) - 1
),
INTERVAL 1 WEEK
) AS week_start,
subdate(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
date_format(
DATE_FORMAT(
(
SELECT
etl_time_base
FROM
cpu_bq.etl_base_config
),
'%Y-%m-%d 00:00:00'
),
'%w'
) - 1
) AS etl_week_end
——————————————————————————————————————————————
参考网上内容
SELECT SUBDATE(NOW( ), 1) AS 'Yesterday', SUBDATE(NOW( ), INTERVAL -1 DAY) AS 'Tomorrow';