CODE EXAMPLE FOR SQL

postgresql extract hour and minutes from timestamp

 select to_char(YourTimeStampField,'HH24:MI:SS')