how to extract hour from date column

[#1]

I have a date column (Calendar_Dt) and want to exactract Hour from that column.i need to use this hour column in dimensions to display as 00 to 23, the complete 24 hours has to display in bar chart. So that based on hour i am calucating answered, abandoned calls like that.. can anybody help me on this. thank you.

[aj0031724]

Dear Avinash ,

Can you advise me with the below request from posted thread yeterday .How can I build the logic?

STRAIGHT TABLE DATE CAN BE MAPPED WITH 0-23 hours and then do the logic based on HOUR filter.?