Date Problem in DB2.

building semantic layer
1

Hi DB2 Folks,

I am breaking my head on the wall to find out what is the wrong with the datetime columns. Here is the Scenario:

  1. I am using ‘Date’ functions for all the date type columns, because, to avoid time stamp.

  2. I am using all the date objects in the (result objects) report without any problem.

  3. I tried to create a condition based on the date range and ran the report, I got the error message as follows
    "The string representation of a datetime value is out of range. "

  4. I tried to select the values from LOV, it showed date&time eventhough I used Date function on that object and changed the format in the universe.

  5. I changed the format ‘mm/dd/yyyy’ as in database on that object in the universe.

I tried all the possibilities, but end in vain.

Please folks, help me out on this issue. What are the other possibilities to solve this problem? Any BO Driver problem?

Thanks
Ravi.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

2

Which db2 version you are using ? Db2/nt or db2/mvs and V5.2.3 or V6.1

Hi DB2 Folks,

I am breaking my head on the wall to find out what is the wrong with the datetime columns. Here is the Scenario:

  1. I am using ‘Date’ functions for all the date type columns, because, to avoid time stamp.

  2. I am using all the date objects in the (result objects) report without any problem.

  3. I tried to create a condition based on the date range and ran the report, I got the error message as follows
    "The string representation of a datetime value is out of range. "

  4. I tried to select the values from LOV, it showed date&time eventhough I used Date function on that object and changed the format in the universe.

  5. I changed the format ‘mm/dd/yyyy’ as in database on that object in the universe.

I tried all the possibilities, but end in vain.

Please folks, help me out on this issue. What are the other possibilities to solve this problem? Any BO Driver problem?

Thanks
Ravi.

Listserv Archives (BOB member since 2002-06-25)

3

In DB2/MVS…We have defined DB2 date columns as Character in BusinessObjects and it works fine.
Try doing that…

-Durgesh

Hi DB2 Folks,

I am breaking my head on the wall to find out what is the wrong with the datetime columns. Here is the Scenario:

Listserv Archives (BOB member since 2002-06-25)

4

We had the same problem at one time,
switching the database format
(Advanced Tab on the Objects Properties Box) to ‘yyyy-mm-dd’ did the trick.

I think Business Objects was going to address this problem in a future release (5.0.1?)

-Chris

From: Business Objects [SMTP:businessobject@HOTMAIL.COM]

Hi DB2 Folks,

I got the error message as follows
"The string representation of a datetime value is out of range. "

  1. I changed the format ‘mm/dd/yyyy’ as in database on that object in the universe.

Ravi.

Listserv Archives (BOB member since 2002-06-25)

5

I am using DB2/MVS V6.1.

Date: Fri, 3 Mar 2000 11:31:37 +0100

Which db2 version you are using ? Db2/nt or db2/mvs and V5.2.3 or V6.1

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)