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

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!