Tuesday, 2 December 2008

Informix Roundup: 02 Dec 2008

OAT 2.23 is available.

Jacques Roy has more timeous goodness.

IBM reseller on the run after beating up business partner and committing fraud. Allegedly. (Nothing to do with Informix, but let's face it, it's more interesting than a stored procedure. :o)

1 comment:

HeartAttackSurvivor said...

But DBINFO is your friend!

UTC to real time function:
select DBINFO ('utc_to_datetime', 972823776)
from systables where tabid = 1 ;
(or whatever timestamp you have)

And there's a reverse one which you can tit about with to get a datetime from a unix timestamp:
select dbinfo('utc_current') from systables where tabid = 1;

So why all the SPL crud?