Re: how to find the 2 months old rec

Keith Simmons wrote: > IDS is a relational database and therefore has no implicit > ordering, ie later records are not stored 'after' earlier ones. > The answer therfore is no, unless you maintain your own > date/time fields you cannot retrieve records for specific > date periods > > Keith > > On 19 Sep 2006 01:43:42 -0700, calyanram@hotmail.com > <calyanram@hotmail.com> wrote: > > Hi > > > > I just want to find out the 2 months old record in a table. > > > > but there is no timestamp in table? > > > > how to find out ? is there any systables available for this? > > > > thanks in advance > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > It may not be very reliable , however you might be able to an idea of rows you want if you use the Rowid if you can figure out what rowid is for the date range you want