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

Yogesh
Yogesh
in Magic ETL

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

Comments

  • GrantSmith
    GrantSmith Coach

    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 Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories