Remove date from timestamp

Natalia · 2021-04-30T18:11:21+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

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

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

It worked, thanks!