I want to give columns name as current_date-1

Viewed 25

I want to give columns name as current_date-1

below is the code.....

SELECT 
user_id
,SUM(CASE WHEN DATE(log_date)=DATE(CURRENT_DATE-1) 
       THEN working_hrs END) AS DATE(CURRENT_DATE-1) 
FROM 
log_times 
GROUP BY user_id

0 Answers
Related