Re: SCO Opensever 5 & Informix 5 SE Date Format problem ?
stephen.mcs@ukonline.co.uk wrote:
>
> I've moved our database from a SCO 3.2-4.2 server running Informix 5
> SE to a new machine running SCO Openserver 5 (5.03) and Informix 5 SE.
>
> The problem I have encoutered is the date format seems to have
> switched from dd/mm/yyyy to mm/dd/yyyy even though I have DBDATE="DMY4/"
>
> in my .profiles. Both when running the application and accessing
> tables via dbaccess ? Is this a SCO problem or Informix problem?
There was a 'feature' a while back where the engine (I think) forgot to
look at DBDATE and just used the American default. Usual solution;
upgrade to the latest versions. For OnLine & SE it must be about
version 5.10. This will require an upgrade of the OS though.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+