Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert to 24hour format like (0, 1,2,3 till 23)
Try this
Time#(Hour, 'hA') AS Hour24
This perhaps?
Time(Time#(Hour, 'hhTT'), 'h') as [24Hrs];
It is showing only from 1 to 14 hour
From 15 to 24 it is showing
I mean from 15 to 24 hour is not displayed.
Only from 1 to 14 hour is coming