Convert seconds to time format

[#1]

Hi,

I have calculated field in script as Second and now I want to convert it to time format.

for eg. 5326 to 01:28:46

[Chanty4u · Accepted solution]

hi,

try lik dis

Interval(TIME_SECONDS/86400, 'hh:mm:ss') as TIME_1

[Chanty4u]

ref

Rounding Errors

[Kushal_Chawda]

see this

Time Difference or Time in Human Readable Format

[tamilarasu]

Try,

Expression:

=Timestamp(FieldName/86400  ,'hh:mm:ss')

Script:

Timestamp(FieldName/86400  ,'hh:mm:ss') as Time

[Chanty4u]

or else

time(YourField/3600/24, 'hh:mm:ss') as YourFiled

Sample attached

[#7]

U can the time funcion

=time('field'/3600,'hh:mm')

[HirisH_V7]

Hi,

May be like this,

Data:
LOAD * ,
Time(Time#(Field,'ss'),'hh:mm:ss') as Time
INLINE [
Field
5326
];

Output:

In Text Box:

=Time(Time#(Field,'ss'),'hh:mm:ss')

HTH,

PFA,

Hirish

[#9]

Try,

Expression:

=Timestamp(FieldName/86400  ,'hh:mm:ss')

Script:

Timestamp(FieldName/86400  ,'hh:mm:ss') as Time