how to find the 2 months old rec

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

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 >