Processing date and time in AWS Redshift

Since AWS Redshift don’t have function like FROM_UNIX(), it’s much more weird to get formatted time from a UNIX timestamp (called ‘epoch’ in Reshift):

Ref: https://stackoverflow.com/questions/39815425/how-to-convert-epoch-to-datetime-redshift

If we want to see the statistics result group by hours:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.