Need help with query

[Igor Kravzov]

Hi,

I have a query like this one

alter table my_table
  add if not exists partition (yyyymmdd=20160912) location
'/mylocation/20160912';

Is it possible to make so I don't have to change date every day?
Something with  CURRENT_DATE;?

Thanks in advance.