如何从postgres中的查询提取小时

I have timestamp in my table and i want to extract only hour from it. I search and find a extract function but unable to use as a query. Do i need to convert first timestamp in varchar and then extract hour from it? Here is my query:I have timestamp in my table and i want to extr