To Get YEARMONTH from date in Athena

user_16557399 0
Viewed 2679

I can get year and month separately in Athena but i don't know how to get YEARMONTH from date.

select year(date1) from table1
select Month(date1) from table1

Please suggest how to get YEARMONTH. Thank you in advance.

yearmonth amazon-athena
1 Answers

You can use date_format to represent your date in needed format:

select date_format(now(), '%Y%m')
user_25012790
Related