Re: INTERVAL is driving me crazy

Posted in 1999

Cliff Burton — Thu, 14 Oct 1999 10:48:46 EST — source: Informix-list mailing list archive (1991-1998)

Hi, Not quite sure what operation you are using so I'll give you an SQL select statement: SELECT CURRENT - 480 UNITS MINUTE FROM SYSTABLES WHERE TABID = 1; >From: "David Henry" <henryd@net-gong.com> >Reply-To: "David Henry" <henryd@net-gong.com> >To: informix-list@iiug.org >Subject: INTERVAL is driving me crazy >Date: Wed, 13 Oct 1999 18:21:14 +0200 > >I'm trying to convert datetime values from one timezone to another, however >it >seems that the value of INTERVAL can only be a constant. >Any ideas how I can increment/decrement a DATETIME according to an INT >variable that represents minutes? > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com