Probleme mit Discoverer 10 Plus u Viewer

[hannes82]

hallo,

ich habe folgendes problem mit Version 10 Plus u Viewer.

Datetime felder werden trotz richtig eingestellter Formatierung falsch dargestellt.
Beispiel: 17.06.09 00:00:00 obwohl in der DB drinsteht: 17.06.09 14:16:17

komischerweise wird in der Desktop Version 10 der Wert richtig dargestellt und zwar: 17.06.09 14:16:17

ich habe keine erklärung dafür, warum die Darstellung in der Plus Version falsch ist! hat wer Erfahrungen damit?

[jum]

Die Anzeige von DATE-Feldern im Client erfolgt je nach den NLS-Parametern: http://download.oracle.com/docs/cd/B...v.htm#i1006741

Teste mal die Unterschiede in der Ausgabe bei:

ALTER SESSION SET nls_territory=germany nls_date_language=german;

ALTER SESSION SET nls_date_format='DD.MM.YYYY';

SELECT TO_CHAR(SYSDATE) FROM DUAL;

ALTER SESSION SET nls_date_format='DD.MM.YYYY HH24:MI:SS';

SELECT TO_CHAR(SYSDATE) FROM DUAL;

[hannes82]

danke für die info. glaube ich habe das problem gefunden ->> siehe:
werde mal den patch installieren und schaun obs dann klappt!

Subject:
Time in Date Fields is Always Displayed as 00:00:00 in Discoverer Plus/Viewer


Doc ID:
358925.1
Type:
PROBLEM


Modified Date:
16-JAN-2009
Status:
PUBLISHED


In this Document
Symptoms
Cause
Solution
References


--------------------------------------------------------------------------------

Applies to:
Oracle Discoverer - Version: 10.1.2.48.18
This problem can occur on any platform.

Symptoms
When formatting a date field to display a time value ( HH:MI:SS), the time is always displayed as 00:00:00.
This only occurs in Discoverer Plus/Viewer version 10.1.2.48.18.

The date fields display the actual 24 hour clock time in Desktop (i.e. 10:15:33).

Cause
Problem is due to known Bug 4707854, TIME FIELD IS ALWAYS SHOWN AS ZEROS IN PLUS AND VIEWER.

Solution
To implement the solution, please execute the following steps:

1. Please contact Oracle Support to request the password for one-off Patch 4707854.

2. When password is obtained, download and review the readme and pre-requisites for
Patch 4707854 TIME FIELD IS ALWAYS SHOWN AS ZEROS IN PLUS AND VIEWER

3. Install the patch as described in the readme and in a test, or non-production, environment first.

4. Please retest the issue.

5. Once the fix is confirmed and fully tested, please migrate the solution as appropriate to other environments.

References
Bug 4707854 - NLS: TIME FIELD IS ALWAYS SHOWN AS ZEROS IN PLUS AND VIEWER

Keywords
TIME~VALUES; DISCOVERER~PLUS; DISCOVERER~VIEWER;