Questions tagged [amazon-presto]

Use for questions about how to use Amazon Presto SQL query engine on Amazon EMR.

1 question with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
31 views

presto from_unixtime to omit milliseconds & timezone string

This is my query SELECT from_unixtime(dispo_epoch,'Africa/Johannesburg') FROM "analytics"."table1" WHERE lead_id = 100000 Result returned is: 2020-03-31 12:37:43.000 Africa/...