cancel
Showing results for 
Search instead for 
Did you mean: 

Convert GMT time on the report/universe to PST time

Former Member
0 Kudos

Hello all,

Really appreciate any help on this issue.

My reports are giving output on GMT based off the server machine configuration. I need to create a variable at the report level to covert the time to PST

for eg. if its Sep 8, 2010 05:20:00 PM i want to create a variable to convert this to PST and show it as Sep 8, 2010 10:20:00 AM (-7 hrs).

Or need some help to make a object at the universe itself.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I don't think this is possible directly/ easily at the report level. What's the data source (for the universe).

Former Member
0 Kudos

thanks for the reply Srinivas, the datasource is Oracle 10G. I have a synatx to convert the timestamp at the database level by adding a column. But i am looking for a variable at the report level.

To reply to the earlier post, the settings on the Infoview is PST.

Edited by: celsiusguru on Nov 1, 2010 9:52 PM

Former Member
0 Kudos

Option 1

You could use the NEW_TIME function in Oracle to achieve this. This allows one to convert date/time in one time zone to date/time in another. There's more information on usage available at http://www.techonthenet.com/oracle/functions/new_time.php .

Option 2

You could create another date/time object and subtract 7 hours from it. For example, if your date/time object is called DateTimeGMT, DateTimePST would be

Table.DateTimeGMT - 7/24 

Best,

Srinivas

Former Member
0 Kudos

Where BO E installed on PST time zone machine or local/User's??

In PST means then it should show PST timeline.

Can you try to change Infoview preferences??

How about result after using CurrentDate() function in report?? GMT or PST

Gracias...!!