Remove decimal from time format

tstimple

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

 

GrantSmith

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/highlight/true#M8465. That will give you a way to customize your display of the days, hours, minutes and seconds and strip off the decimals.