how do I convert data time field to yyyy-mm-ddThh:mm:ss

Reply
Highlighted
Yellow Belt

how do I convert data time field to yyyy-mm-ddThh:mm:ss

so that when i export the file shows 2020-09-14T11:56:43 instead of 14-Sep-20 11:56:43 ? 

Tags (1)
Highlighted
Red Belt

Hi @Yogesh 

That's because it's the raw data you're seeing. Domo will take that raw data and change how it's displayed in the cards itself. If you're wanting to export the raw data as a formatted string you'd need to create a beast mode to return the date formatted.

 

DATE_FORMAT(`Timestamp Column`, '%Y-%m-%d %H:%m:%S')

 



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.