Re: date
Try the following SQL
select * from table_name
where last_update >= (today - 3 units month)
This will give you the result that you are expecting.
Gopi.
-----Original Message-----
From: Min Kim <mkim@icpma.com>
To: informix-list@iiug.org <informix-list@iiug.org>
Date: Tuesday, May 25, 1999 1:33 PM
Subject: date
>This is a multi-part message in MIME format.
>--------------586E31CEA8B0634DC4778107
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>hi,
>can someone please tell me why "select * from tableName where (TODAY -
>last_update < 3 units month)"
>
>does not work? it gives the error cannot convert between types. can
>someone give me the syntax to get all records that are 3 months old or
>less?
>
>Min
>
>--------------586E31CEA8B0634DC4778107
>Content-Type: text/x-vcard; charset=us-ascii;
> name="mkim.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Min Kim
>Content-Disposition: attachment;
> filename="mkim.vcf"
>
>begin:vcard
>n:Kim;Min
>x-mozilla-html:FALSE
>org:ICP;Information Technology
>adr:;;;;New York;;USA
>version:2.1
>email;internet:mkim@icpma.com
>title:Consultant/Programmer - Internet Services
>fn:Min K. Kim
>end:vcard
>
>--------------586E31CEA8B0634DC4778107--
>