Amazon Athena -Metabase time sync

I am facing issue with metabase and athena timezone syncing, my metabase timezone is Asia/Kolkatta but the athena default timezone is utc.
If i do select now() on metabase it shoes result in UTC.
This command of athena does not work on mysql:
select now(), now AT TIME ZONE 'Asia/Calcutta'

Not sure if you had a look at Supported time zones - Amazon Athena