Remove decimal from time format

Yellow Belt

Remove decimal from time format


I have a very simple calculation to get time since the last record up to today's current time:


CURRENT_TIMESTAMP() - MAX(`sys_created_on`)


This seems to work fine and returns a time formatted like this for example:

2 02:34:26.0000


How do i modify my formula to remove the ".0000" part?





Black Belt

Hi @tstimple 

I've written up a similar solution utilizing UNIX_TIMESTAMP, some simple math and the CONCAT function. I'd recommend taking a look at That will give you a way to customize your display of the days, hours, minutes and seconds and strip off the decimals.

**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!