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?
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.