interval result formatting

[#1]

Hello,

I would like formating the result of durationminutes like a number #.### but I don´t know How can I do it?

I need to show IncidenceDurationMin with thousand point

Schedule:

LOAD :

Incidencetart,

Incidenceend,

time(datetime_start-datetime_end,'hh:mm:ss') as IncidenceDuration,

interval(datetime_start-datetime_end,'mm') as IncidenceDurationMin

FROM [SCHEDULETIME.XLS];

[Gysbert_Wassenaar]

Try: num(floor(datetime_start-datetime_end*60*24),'#.##0') as IncidenceDurationMin

[swuehl]

Ana, please be patient if you don't receive answers immediately and try to avoid multiple postings about the same request:

Format an interval result as ###.###

P.S: I guess there should be brackets around the difference calculation in Gybert's expression and probably an end-start calculation

num(floor( (datetime_end-datetime_start) *60*24),'#.##0,',',','.') as IncidenceDurationMin

[Gysbert_Wassenaar]

Good point. I missed that there were two fields.

[MarcoWedel]

Hi,

see your other thread

Re: Format an interval result as ###.###‌

hope this helps

regards

Marco