Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
try lik dis
Interval(TIME_SECONDS/86400, 'hh:mm:ss') as TIME_1 |
Try,
Expression:
=Timestamp(FieldName/86400 ,'hh:mm:ss')
Script:
Timestamp(FieldName/86400 ,'hh:mm:ss') as Time
or else
time(YourField/3600/24, 'hh:mm:ss') as YourFiled
Sample attached
U can the time funcion
=time('field'/3600,'hh:mm')
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
Try,
Expression:
=Timestamp(FieldName/86400 ,'hh:mm:ss')
Script:
Timestamp(FieldName/86400 ,'hh:mm:ss') as Time