Home » Fusion Middleware & Colab Suite » Business Intelligence » Oracle Date Timestamp
Oracle Date Timestamp [message #577581] Mon, 18 February 2013 14:40 Go to next message
Afaf
Messages: 1
Registered: February 2013
Location: India
Junior Member
I have a Delivery Date Object, backend Oracle.
I set it as Cast(Delivery Date as Timestamp). In the object properties, i check display values it shows
01/20/13 13:24:36
BUT in Webi only shows that Date part, I can format it there...but on its own, it doesn;t show the timestamp part.

NOW Manager says need to show in Webi as this format: mm/dd/yyyy hh:mm:ss AM/PM
So i have to fix in universe and they want to see in webi as above, wothout any formatting in webi...

I tried many different ways, ..Any idea?
Re: Oracle Date Timestamp [message #577590 is a reply to message #577581] Tue, 19 February 2013 00:12 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You used some terms I'm unfamiliar with (such as "webi", "universe"); moreover, I never used Business Intelligence so - if these terms are related to it, my bad. Anyway: Oracle stores date in its own, internal format, which is not readable by us, human. Therefore, we have to use format mask to display date values as we want. For example (SQL*Plus output):
SQL> select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss') right_now from dual;

RIGHT_NOW
-------------------
02/19/2013 07:10:01

Another option is to set NLS_DATE_FORMAT; this is what SYSDATE looks like by default on my database:
SQL> select sysdate from dual;

SYSDATE
-------------------
19.02.2013 07:10:49
If I want, I can change it:
SQL> alter session set nls_date_format = 'dd, day mm.yyyy. hh24:mi';

Session altered.

SQL> select sysdate from dual;

SYSDATE
----------------------------
19, tuesday   02.2013. 07:11

So I was thinking: maybe you could/should do the same. As I said - I have no idea where would you actually do it, but - perhaps examples you saw will help a little bit.
Previous Topic: BI server not starting
Next Topic: RTF Template for Excel Output
Goto Forum:
  


Current Time: Thu Mar 28 18:11:47 CDT 2024