Re: how to check for system date in informix?

Posted in 1999

Christian Brauer — Wed, 08 Sep 1999 13:15:40 +0200 — source: Informix-list mailing list archive (1991-1998)

You could try SELECT TODAY FROM informix.systables WHERE tabid = 1 You may exchange TODAY against CURRENT YEAR TO MONTH (or HOUR TO SECOND for system time) if you have to. Hope this helps, Christian Brauer