Remove date from timestamp

Natalia

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.

MarkSnodgrass

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')

Natalia

It worked, thanks!