Remove decimal from time format

Reply
Yellow Belt

Remove decimal from time format

Team,

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?

 

Thanks

Tim

 

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 https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Date-Calculations-minutes-and-seconds/m-p/49259/hig.... 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!**
Announcements
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!