TO_CHAR? or not to char

Posted in 1999

Bridget Reitsma — Fri, 08 Oct 1999 10:41:51 +1300 — source: Informix-list mailing list archive (1991-1998)

Hi Informix = 730UC5. Does anyone know if informix has a TO_CHAR function that a certain other database does that starts with the letter 'O' and ends in 'racle'. It changes date/time or other fields to character so you can compare them. For our off the shelf application (PeopleSoft) we need to implement this to check a start date against a date entered on a report which just happens to be character field - they have given us an oracle answer and say they don't know if informix supports it. thanks Bridget

↪ replying to Bridget Reitsma

mfmqazi@hotmail.com — Fri, 08 Oct 1999 00:08:30 GMT — source: Informix-list mailing list archive (1991-1998)

Informix 7.3 does support TO_CHAR. Check the Informix Guide to SQL Tutorial. Page 2-72 Regards, Musaddique Qazi In article <37FD139F.FBBFFF13@auckland.ac.nz>, Bridget Reitsma <b.reitsma@auckland.ac.nz> wrote: > Hi > > Informix = 730UC5. > > Does anyone know if informix has a TO_CHAR function that a certain other > database does that starts with the letter 'O' and ends in 'racle'. It > changes date/time or other fields to character so you can compare them. > > For our off the shelf application (PeopleSoft) we need to implement this > to check a start date against a date entered on a report which just > happens to be character field - they have given us an oracle answer and > say they don't know if informix supports it. > > thanks Bridget > > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Bridget Reitsma

Steven Mastandrea — Fri, 08 Oct 1999 08:04:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Informix also does implicit conversions of certain fields if you are not on Version 7.3X. We are using version 7.23, and do: select * from systables where "10/08/1999" = ("" || TODAY) Of course, you can replace TODAY with your date field. If you use a datetime field, I believe the "" || FIELD format is CCYY-MM-DD HH:SS. HTH, --Steven Bridget Reitsma wrote: > Hi > > Informix = 730UC5. > > Does anyone know if informix has a TO_CHAR function that a certain other > database does that starts with the letter 'O' and ends in 'racle'. It > changes date/time or other fields to character so you can compare them. > > For our off the shelf application (PeopleSoft) we need to implement this > to check a start date against a date entered on a report which just > happens to be character field - they have given us an oracle answer and > say they don't know if informix supports it. > > thanks Bridget -- ----------------------------------------------------- Steven Mastandrea stevem@cstech.com Systems Designer 847.397.7300 CSTech, Inc. Schaumburg, IL