You can try using cast:
Code:
select current, current::datetime hour to hour from
systables where tabid=1
If you need int type as result, you can use couple more of casts:
Code:
select current, current::datetime hour to hour::char(2)::int from
systables where tabid=1
HTH