Re: SQR Date problem/Informix

[Al <starbuckk1@YAHOO.COM>]

Thanks to all for responses.  The problem was related to an Informix
setting that we had to change in SETNET32.  The DBDATE= setting needed to
be adjusted to reflect the correct format, which in our case was DBDATE=Y4MD.


At 12:00 AM 05/25/2001 -0600, you wrote:
>Date:    Thu, 24 May 2001 17:17:40 +1000
>From:    Mark Pietersz <MPietersz@ADECCO.COM.AU>
>Subject: Re: SQR Date problem/Informix
>
>Al,
>
>There's a number of possible reasons for this.
>
>Have you check the following in your pssqr.ini file to see if it is the
>format supported at your site ?
>
>[Environment:Sybase]
>SQR_DB_DATE_FORMAT=YYYY-MM-DD HH:MI:SS.NNN
>
>You could also utilize the data conversion function datetostr which (i
>think) was introduced in later (4.3 +)
>versions of SQR
>
>Regards
>
>Mark Pietersz