Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have "Time" field in the database with below format :
2 days 11:10:05
I need to convert the days in hours.
The result should be 59:10:05
Thanks
@Shahzad_Ahsan One option:
subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3)
like for example :
Data:
load *,
subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3) as NewTime inline [
Time
2 days 11:10:05
3 days 12:30:55
];
output:
@Shahzad_Ahsan One option:
subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3)
like for example :
Data:
load *,
subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3) as NewTime inline [
Time
2 days 11:10:05
3 days 12:30:55
];
output:
Thank You @Taoufiq_Zarra
Its working. 😊