>>You don't have to use constant at all.

? RIGHT(TTOC( DTOT(DATE()) + lnSeconds),8)

>
>That's another good way to achieve the same.

I realized that it would produced desired result only if SET HOURS set to 24. Here's the code that will return correct result regardless of any date/time settings.

? TRANSFORM(RIGHT(TTOC( DTOT(DATE()) + lnSeconds,1),6), "@R 99:99:99")