Re: How to get system time with SQL?

Posted in 1998

ALPESH SHAH — Fri, 18 Sep 1998 14:47:59 +0530 (IST) — source: Informix-list mailing list archive (1991-1998)

Hello , In case of Informix there is no concept of dummy table as that in oracle But , still one may be interested in this way than it requires to have an exsiting table. query = select CURRENT/TODAY FROM <table name> But be sure that table must have only one row otherwise it may result in in multiple o/p. in such case supply necessary where condition so that it will result in only single row o/p. Thanks In Advance. With Regards , [ ALPESH SHAH ] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Email I. D. # alpesh.shah@tatainfotech.com ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On Fri, 18 Sep 1998 owner-informix-list@iiug.org wrote: > 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. > > > >