SQL code for Athena: convert timestamp to different timezone
Budget: $10 – $30 USD
I have a database with a column that contains timestamps in bigint format. The timestamps are in UTC time zone.
I need a piece of code to insert in a SELECT statement in Athena that converts the timestamp data to Thailand/Bangkok time and also converts it into the columns ‘date’ and ‘time’ (based on the Bangkok time). I am a beginner in SQL and can’t figure out how to do this.
Small-size database attached.
I need a piece of code to insert in a SELECT statement in Athena that converts the timestamp data to Thailand/Bangkok time and also converts it into the columns ‘date’ and ‘time’ (based on the Bangkok time). I am a beginner in SQL and can’t figure out how to do this.
Small-size database attached.