Convert Time from Central Time to Time Zone Data is in

[dmt4cats]

In the data mart I am pulling data from, all times are stored in Central Time. Is there an easy way to convert this time to the time zone for the State.

I thought they may be some type of function to convert this type of data.

Thank you for any help you can provide.

 

[Naith]

You could use a formula for this at the report level, but I tend to handle this at the database level. If your database is on Solaris, there will be a TZ (TimeZone) variable setting which the database picks up from.

If you have to handle this in the report, then you'll have to use the state to assign the relevant time zone.

e.g. If {State} in [X,Y,Z] then TimeVar Time := {Time}+/-n

Naith

 

[dmt4cats]

Thank you for your help.