Time Conversion, from GMT to PST

building reports desktopintelligence
1

Hi,

I’ve tried to look for this topic in the Archives but could not find what I was looking for.

I have a date and time field [m/dd/yyyy hh:min:ss] in Oracle 9.1 that’s stored as Greenwich Mean Time (GMT). Could someone tell me how I could convert this to Pacific Standard Time (PST) in BO Reporter?

Thanks,

Henry

henrychebo :us: (BOB member since 2002-11-01)

2

I would do that in Designer, actually. I think you can call a function in Oracle (although I don’t recall the exact name at the moment) that will convert from one time zone to another.

Otherwise you’ll be stuck doing time manipulation in Reporter, and there aren’t any functions that are set up to do that. Date math, yes. Time math, unfortunately not.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

For Oracle try:

New_Time (DateColumn, 'SourceTimeZone', 'TargetTimeZone')

For example:

New_Time (DateColumn, 'EST', 'CST')

to convert from Eastern Standard Time to Central Standard Time

Andreas :de: (BOB member since 2002-06-20)

4

Thanks Andreas and Dave.

Andreas, where would I put that code you gave in Designer?

Henry

henrychebo :us: (BOB member since 2002-11-01)

5

Just put the code in the Select Box of your universe object in Business Objects Designer…

Andreas :de: (BOB member since 2002-06-20)

6

Andreas,

The code worked like a charm. Thanks! :lol:

Henry

henrychebo :us: (BOB member since 2002-11-01)

7

This does work like a charm :slight_smile: