Discussion board where members can get started with QlikView.
I am trying to extract the 24 hour time from a timestamp Date Time
,Time(round(frac([TransCont DateTime]),1/24), 'hh') as [TransCount 24 Hours]
but the the table is showing
I noticed its converting 9.30-10.30 as 10 and 10.30-11.30 as 11.
Please anyone got any idea? how can i create a correct table
Go to Solution.
That's because you are using round(), and those appear to be correct rounding. If you just want the hour, use:
View solution in original post
Below script working for me, please check
Hour(TimeStamp#(TimeStam, 'M/D/YYYY hh:mm tt' )) AS Hour
Thank you Rob,
anybody solve this please