date

Posted in 1999

Summary

Min Kim asked why a WHERE clause using TODAY - last_update < 3 units month failed with a cannot convert between types error, and how to select records three months old or less. Carlson suggested today - date(last_update) < 90. Rob Vorbroker suggested last_update < (TODAY - 3 units month). John Bejarano suggested using CURRENT (datetime) instead of TODAY (date). No confirmation of which worked.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Min Kim — Tue, 25 May 1999 10:36:50 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Min Kim

Carlson@WHSmith — Tue, 25 May 1999 12:55:38 -0400 — source: Informix-list mailing list archive (1991-1998)

What about select * from Table where today - date(last_update) < 90 John Carlson Informix DBA WHSmith USA Min Kim wrote: > > 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 > > ------------------------------------------------------------------------ > > Name: mkim.vcf > mkim.vcf Type: VCard (text/x-vcard) > Encoding: 7bit > Description: Card for Min Kim

↪ replying to Min Kim

robertb..vorbroker — Tue, 25 May 1999 17:35:17 GMT — source: Informix-list mailing list archive (1991-1998)

In DBACCESS try SELECT * from tablename where last_update < (TODAY - 3 units month) that should do it I think... Rob Vorbroker Min Kim <mkim@icpma.com> wrote in message news:374AB582.342850CD@icpma.com... > 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 >

↪ replying to Min Kim

John Bejarano — Tue, 25 May 1999 10:42:15 -0700 — source: Informix-list mailing list archive (1991-1998)

Min, Instead of using 'TODAY', which is of data type date, try using 'CURRENT' which is of data type datetime year to fraction(5). Kind regards, John Bejarano. Min Kim wrote in message <374AB582.342850CD@icpma.com>... >hi, >can someone please tell me why "select * from tableName where (TODAY - >last_update < 3 units month)" > >does not work?