Re: How to get DB Server Date and TIme ?

>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" Adding _one_ bit: I would have thought WHERE tabid=1 was marginally more efficient. ;-) >>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 >>> >>> >> >> > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com