Time detail not reflecting

[nareshthavidishetty]

Hi,

Am used the below logic at script level to get the time format,

Script level:   'Time(Time#(BGCMTM, 'hhmmss'), 'hh:mm:ss') as Reporting_Time'

But am getting an issue like as below(For 8:00:00 and 9:00:00 times were missing but in bakend it is available).

Thanks..

[nareshthavidishetty]

It's rounding to 7:59:00 t0 8:00:00,

Time(Ceil(Time#(Num(BGCMTM, '000000'), 'hhmmss'), (1/(24*60))), 'hh:mm:ss') as New_Time

Thanks...

[sunny_talwar]

It should have been rounding down to the nearest minute, but you want to round down to nearest hour, try this:

Time(Floor(Time#(Num(BGCMTM, '000000'), 'hhmmss'), (1/24)), 'hh:mm:ss') as New_Time

[sunny_talwar]

You can try these also:

Time(Round(Time#(Num(BGCMTM, '000000'), 'hhmmss'), (1/24)), 'hh:mm:ss')

or

Time(Floor(Time#(Num(105900, '000000'), 'hhmmss'), (1/24)), 'hh:mm:ss')

or

Time(Ceil(Time#(Num(105900, '000000'), 'hhmmss'), (1/24)), 'hh:mm:ss')

[nareshthavidishetty]

Thanks Sunny these were really helpful..