Athena - Stripping the 'Time Zone' part from the timestamp after converting from UTC to EST

Asked Oct 12 '22 at 12:08

Active Oct 12 '22 at 18:19

Viewed 509 times

I'm converting the timestamp column, which is by default in UTC, into EST by using 'AT TIME ZONE' clause (America/New_York or EST5EDT). However, the resulting text displays the timestamp along with the time zone. E.g: '2022-10-12 07:30:00.000 EST5EDT' .

I tried casting it to timestamp, cast(result as timestamp), but this converts it back to UTC.

edited Oct 12 '22 at 18:19

Guru Stron

102,774
10
95
132

asked Oct 12 '22 at 12:08

redwolf_cr7

1,845
4
26
30

2

Looks helpful: [sql - Presto: Cast timestamp w/TZ to plain timestamp WITHOUT converting to UTC - Stack Overflow](https://stackoverflow.com/questions/48633900/presto-cast-timestamp-w-tz-to-plain-timestamp-without-converting-to-utc) – John Rotenstein Oct 12 '22 at 12:15
I can confirm: You have to play around with substrings. We had this usecase in our project already. – ExceptionNotThrownException Oct 12 '22 at 12:41
@JohnRotenstein, your suggestion definitely helps. Thank you! – redwolf_cr7 Oct 12 '22 at 14:01

Athena - Stripping the 'Time Zone' part from the timestamp after converting from UTC to EST

0 Answers0