Time Format

[nareshthavidishetty]

Hi,

We have pulled the report_time field directly from DB and it shows as below,

Report_time = 100000,110000,120000 (Actually it means 10,11,12)

Here i need to convert this into HH:MM format.Please suggest on this.

Thanks..

[swuehl · Accepted solution]

Mybe like

Time(Time#(Report_time,'hhmmss'),'hh:mm') as NewTime

[sunny_talwar]

May be this in the script:

Time(Time#(Report_time, 'hhmmss'), 'hh:mm:ss') as Report_time

[Chanty4u]

try this

timestamp(alt(TImestamp#([Report_Time],'DD-MM-YYYY hh:mm:ss'),

TImestamp#([Report_Time],'DD-MMM-YY hh.mm.ss.fff TT')),' HH:MM') as date