티스토리 뷰

공부

[Presto] month ago

seunggabi 승가비 2020. 8. 10. 22:30
date '2019-01-01' - interval '2' month

https://stackoverflow.com/questions/54155698/presto-sql-get-yyyymm-minus-2-months

 

Presto SQL get yyyymm minus 2 months

I am using Presto. I have an integer column (let's call the column 'mnth_nbr') showing year and month as: yyyymm. For instance, 201901. I want to have records showing all dates AFTER 201901 as well...

stackoverflow.com

 

'공부' 카테고리의 다른 글

[Java] convert integer to string with comma for thousands  (0) 2020.08.11
[Python] pretty print JSON  (0) 2020.08.10
[Presto] month ago  (0) 2020.08.10
[Java] @JsonProperty show `is` prefix  (0) 2020.08.10
[Sh] for  (0) 2020.08.10
[Sh] convert string to date  (0) 2020.08.10
댓글
댓글쓰기 폼