RE: How to get system time with SQL?

Posted in 1998

Thomas Tatum — Fri, 18 Sep 1998 10:05:59 -0400 — source: Informix-list mailing list archive (1991-1998)

I was told from this group last year a good way to do this was: select current from systables where tabid = 1; Has anyone else had errors with current? We are running IUS 9.14UC3 on solaris. > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of '''' > Sent: Thursday, September 17, 1998 10:15 PM > To: informix-list@iiug.org > Subject: How to get system time with SQL? > > > Hi everybody, > How to get system time with SQL? > like as ' Select sysdate from dummy' the Orcale. > > Thanks! > I am James Chung at Taiwan Taipei. > > >