Getting hour value in informix

denizcaglar · #1 (**permalink**) 12-21-08, 10:24

Hi

How can we get the hour value of a datetime value in informix ?

For example i need to get 05 from '18.12.2008 05:10:00'

Thanks.

ibm.ids · #2 (**permalink**) 12-21-08, 12:11

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

denizcaglar · #3 (**permalink**) 12-21-08, 16:48

Thank you very much