Remove date from timestamp

Natalia
Natalia Member
edited April 2021 in Charting

Hello,

 

If I have a timestamp that includes month, day, year, hour, minute, second, as follows: 

2020-08-12T16:57:45Z

 

How do I get a timestamp that shows just the time and not the date?

 

Thank you.

Best Answer

  • MarkSnodgrass
    Answer ✓

    You could do this in a beast mode and it would put it in the 24 hour format without the date:

    DATE_FORMAT(fieldname,'%T')

    or this to put it in the AM/PM format:

    DATE_FORMAT(fieldname,'%r')

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    You could do this in a beast mode and it would put it in the 24 hour format without the date:

    DATE_FORMAT(fieldname,'%T')

    or this to put it in the AM/PM format:

    DATE_FORMAT(fieldname,'%r')

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • It worked, thanks!