| Oracle Date Timestamp [message #577581] |
Mon, 18 February 2013 14:40  |
 |
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  |
 |
Littlefoot
Messages: 21823
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 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
