공부
[spark] sql yesterday
승가비
2022. 9. 14. 13:13
728x90
How to get today -"1 day" date in sparksql?
How to get current_date - 1 day in sparksql, same as cur_date()-1 in mysql.
stackoverflow.com
SELECT DATE_FORMAT(DATE_ADD(CURRENT_DATE(), -1), 'yyyy-MM-dd')
728x90