Date problem

Date problem

Post by Randy L. Cros » Sun, 31 Dec 1899 09:00:00

Sounds as if you didn't get them .iem (message) files installed
properly and the newer version is generating a message that's not in
the older message file.


> From:          Marco Antonio Muci=F1o Z=FA=F1iga

> Subject:       Date problem
> Date:          Fri, 18 Sep 1998 12:02:40 -0500
> Hi all, I changed my Informix Online 5.01.UD3 to Online 5.10.UC1 and I h=

ave several problems with dates. First : in dbaccess of the new version I =
can't do the following
Quote:> SELECT * FROM table
> if table has a date field. The error is : 1228: Message number not found=
 in message file.
> If I use the dbaccess of the previous version, it works.
> Second : in a 4gl program if I do the following :
> SELECT * FROM table WHERE date_field =3D "01/01/1998"
> the above error ocurrs.
> In all the queries (SELECTs, UPDATEs or DELETEs) where a date field is i=

nvolved in the condition the same error ocurrs. Can somebody help me? Than=
ks in advance.

1. MDX: year-to-date/month-to-date problem

I am having trouble subtracting the year-to-date totals at the quarter
through the month levels of a time dimension to
calculate the month-to-date totals.

I am using the previousmember and currentmember functions, but I cannot make
the calculation use the year-to-date
totals only at the first member of the level (January for month, 1 for
quarter).  For January, the calculation is taking the YTD amount
for the current year minus the YTD amount from the previous year, obviously

                                                         - Thanks, Mike
Parry (MDX novice)

2. Selecting only portion of field.

3. Date problem- date calculation in between values

4. Problem w/stored procedure parameters and sql server 2000

5. date problems

6. PDOX 4.0 and runtime number formatting

7. MSSQL server English-Turkish Date Problem

8. SQL AnyWhere Studio 6.0.1 - VB6 SP3 - Spread 3.0.15

9. Date problem with SQL Server

10. Date problem

11. Please Help: Need SQL Server ODBC client v3.60.x to correct a date problem

12. BCP date problems with SQL7.0

13. Date Problem