Remove date from timestamp

Natalia
Natalia ⚪️
edited April 30 in Card Building

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
    MarkSnodgrass Portland, Oregon 🟤
    Accepted 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')

Answers