Re: HOW COVERT AN INTEGER AN INTERVAL

An alternative SQL: select ( current - current ) + 10 units second from systables where tabname = "systables" will return 10 seconds as an interval day to fraction. In article <706rps$i2q$1@news.xmission.com>, Degtearyov "M.V." <dmv@netinfo-moldova.com> wrote: > > In Informix 4GL, try this: > > ... > DEFINE lChar CHAR(20) > DEFINE lInter INTERVAL minute(3) to ninute > DEFINE lInt INTEGER > > -- Initialization of lInt > LET lInt = 324 > > LET lChar = lInt > LET lInter = lChar > > In SQL, use the same way (thru the char): > > ... > create temp table a (a int) with no log; > create temp table b (b char(20)) with no log; > create temp table c (c interval second(3) to second) with no log;> > insert into a values(32); > insert into b select * from a; > insert into c select * from b;> > It works, however, only in the case of same qualifiers of > interval. > > > Hi: > > I dont know how convert an integer in interval datatype > > > > > > -- > Michael Degtyarev, System analyst > > ----------------------------------------------------------------- > Phone: (373 2) 212096, 243566 45 Banulescu-Bodoni str., > Fax: (373 2) 240083, 213659 POB 164, Chisinau, MD-2001, > eMail: dmv@netinfo-moldova.com Republic of Moldova. > > -- Dennis J Pimple Informix Software, Inc. Denver, CO, USA -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own