changing time format sent to the frontend

Quintin Pearson

My time is a unix timestamp in milliseconds, Have tried to change it to display the date but I had no luck, I get errors or it messes up the entire endpoint, can someone please help 😄

Michael Udinski

 - you can use the format_timestamp filter to format a timestamp into a human-readable format... You can see in our documentation and also watch the tutorial on how to do so at the top of the page there - https://docs.xano.com/working-with-data/timestamp

Coco Wang

 Hi! Nice to meet you. Just wanted to say thank you for the tutorials - they are really informative & helpful! I have a similar question here. I would like to change all timestamp in my query to r format, or preferrably eg. 'MM/DD 4:00pm'. I've tried filtering but it doesn't update the data. Any pointers here? 

Michael Udinski

 - You can use the format_timestamp filter. The tutorial in the docs should cover that and the documentation also links to the character list from php.net that you can use to combine different characters to accomplish this format - https://docs.xano.com/working-with-data/timestamp