In dynamic repository variable initialisation block I have an SQL written. When that SQL is executed in SQL developer its returning a DATE..But when I use that variable in presentation I get a timestamp and have to write CAST(VALUEOF(repository variable name). The requirement is to have DATE value stored in the variable and directly use it in presentation formula..Please let me know why its showing timestamp
Oracle database dates always include a time element.
i.e. Select to_char(sysdate,'DD-MON-YY hh24:mi:ss') from dual;
Note the use of to_char was only to make it obvious the level of accuracy.
In obiee terms this level of accuracy is a timestamp.
Note you can use Select to_char(trunc(sysdate),'DD-MON-YY hh24:mi:ss') from dual; to get 18-JUL-13 00:00:00 - but the time element is still there...
Hope this helps,