Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I wish to turn the number 103729 into hh: mm: ss (10:37:29).
My I do it? And howto?
Try this
Time(Time#(TimeStr,'HHMMSS'),'hh:mm:ss')
hi
you can do something like this
num(left(YOURFIELD,2))/24+num(mid(YOURFIELD,3,2))/1440+num(right(YOURFIELD,2))/86400
try
timestamp(timestamp#(Fieldname,'hhmmss'),'hh:mm:ss')
In Script...
Time(Time#(YourTimeField,'hhmmss')) as YourTimeField
Front End
Time(Time#(YourTimeField,'hhmmss'))
You can try this also
LOAD *,
MakeTime(LEFT(TimeStr,2),mid(TimeStr,2,2),Right(TimeStr,2) ) as MakeNewtime;
LOAD * Inline
[
TimeStr
103729
];
Maketime represents
Maketime (Hour, Minutes, Seconds)
Regards
Anand
Hi,
in case you have 5 digit values for times earlier than 10, this might helps as well:
LOAD *,
Time(Time#(Num(number,'000000'),'hhmmss')) as numberTime
Inline [
number
01234
12345
012346
90123
090124
103729
123456
134556
235959
];
regards
Marco
'HHMMSS'
Using upper case MM (Month) will give some funny results.
-Rob
Thanks it should be always.
Time(Time#(TimeStr,'hhmmss'),'hh:mm:ss')
But need to check correct time format.
Regards,
Anand
Dear,
And one of this the correct one also
LOAD *,
MakeTime(Left(TimeStr,2),Mid(TimeStr,3,2),Right(TimeStr,2) ) as MakeNewtime,
Left(TimeStr,2) as Hours,
Mid(TimeStr,3,2) as Minutes,
Right(TimeStr,2) as Seconds;
LOAD * Inline
[
TimeStr
103729
];
Regards,
Anand