How to get DB Server Date and TIme ?

Posted in 1999

↪ replying to Francis Teo Ee Cheok

Frank — Mon, 8 Feb 1999 22:48:25 -0500 — source: Informix-list mailing list archive (1991-1998)

select CURRENT from <tablename> Francis Teo Ee Cheok wrote in message <79oa1i$olr$3@mawar.singnet.com.sg>... >ANy ideas please email me - thanks alot. > > >-- >Francis Teo Ee Cheok >francis@jnesw.com.sg > >

Francis Teo Ee Cheok — Tue, 9 Feb 1999 11:53:38 +0800 — source: Informix-list mailing list archive (1991-1998)

ANy ideas please email me - thanks alot. -- Francis Teo Ee Cheok francis@jnesw.com.sg

↪ replying to Frank

Dennis Pimple — Wed, 10 Feb 1999 09:17:08 -0700 — source: Informix-list mailing list archive (1991-1998)

Frank wrote in message <79oavq$d44$1@camel19.mindspring.com>... Adding 2 bits: >select CURRENT from <tablename> select unique current ... or have a WHERE that guarantees only 1 value returned. My favorite: select .... from systables where tabname = "systables" > >Francis Teo Ee Cheok wrote in message <79oa1i$olr$3@mawar.singnet.com.sg>... >>ANy ideas please email me - thanks alot. >> >> >>-- >>Francis Teo Ee Cheok >>francis@jnesw.com.sg >> >> > >

↪ replying to Frank

Andreas Asuja — Sat, 13 Feb 1999 17:39:52 +0200 — source: Informix-list mailing list archive (1991-1998)

Frank wrote: > select CURRENT from <tablename> This kinda programming could lead you into trouble if you do this on a big table: The statement goes through every row. (Yeah, done it myself...) ;) As Dennis Pimple wrote, SELECT CURRENT FROM systables WHERE tabid=1; would be the most efficient way of doing this! That's because I assume that systables would reside in the memory all the time!? Cheers, Andreas -- Andreas 'Antti' Asuja - andreas.asuja@iki.fi