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

 

Comments