SELECT
*
FROM
business_info
WHERE
update_time BETWEEN CONVERT (VARCHAR ( 255 ), DATEADD ( DAY,- 1 * ( DATEPART ( WEEKDAY, GETDATE ( ) ) - 6 ), GETDATE ( ) ), 121 ) + ’ 10:00:00’,
AND CONVERT ( VARCHAR ( 255 ), DATEADD ( DAY, 7, DATEADD ( DAY,- 1 * ( DATEPART ( WEEKDAY, GETDATE ( ) ) - 6 ), GETDATE ( ) ) ), 121 ) + ’ 09:59:00’
SELECT
count( DISTINCT business_id )
FROM
business_info
WHERE
country_code = ‘00350200014’
AND save_flag = 1
AND (
update_time BETWEEN ( SELECT concat( SUBDATE( CURDATE( ), DATE_FORMAT( CURDATE( ), ‘%w’ ) + 2 ), ’ 08:30:00’ ) )
AND ( SELECT concat( SUBDATE( CURDATE( ), DATE_FORMAT( CURDATE( ), ‘%w’ ) - 5 ), ’ 08:30:00’ ) )
)
– 本周五
SELECT concat(SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),’%w’)-5) , ’ 08:30:00’);
– 上周五
SELECT concat(SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),’%w’)+2), ’ 08:30:00’);
– 上上周五
SELECT concat(SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),’%w’)+9), ’ 08:30:00’);