to_char function differ at ids 10.x and ids 11.x

[j***@gmail.com]

As far as I know, For informix function to_char()
ids 10.x: convert date or datetime to string only.
ids 11.x : convert time or number to string.
A software company that sold us a package which was developed
on informix server 11.x.
The problem is our informix server is ids 10.x.
When convert number to character it failed.
Can anyone give me some advice to solve this problem?

[Alexandre Marini]

Hello:
You can:
1) build an implicit cast, in order to fit your specific needs
2) upgrade to 11.70 (or 12.10) releases, mainly because your old engine is not anymore under normal support by IBM, and start using the greatest new features

Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70

IBM Information Management Informix Technical Professional

IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

Date: Tue, 25 Jun 2013 05:09:53 -0700
Subject: to_char function differ at ids 10.x and ids 11.x
As far as I know, For informix function to_char()
ids 10.x: convert date or datetime to string only.
ids 11.x : convert time or number to string.
A software company that sold us a package which was developed
on informix server 11.x.
The problem is our informix server is ids 10.x.
When convert number to character it failed.
Can anyone give me some advice to solve this problem?
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list