Adding transformation to convert unix timestamp to %Y-%m-%d format

Summary

How to add a transformation to convert a unix timestamp in a created_at column to %Y-%m-%d format and create a new field called created_at_utc.


Question

Hey folks. I have a created_at column in my dataset which is in unix timestamp format. I want to add another field created_at_utc and convert it to %Y-%m-%d format. How can I add the transformation?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["unix-timestamp", "transformation", "date-format", "created-at-column", "created-at-utc"]