티스토리 뷰

공부

[spark] sql yesterday

승가비 2022. 9. 14. 13:13
728x90

https://stackoverflow.com/questions/41114875/how-to-get-today-1-day-date-in-sparksql/73711441#73711441

 

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
댓글