I am using Crystal Reports against Service Desk for metric reporting. Timestamps in the database are stored in GMT time. My view in HPOVSD is set up for Central Time. Thus, the data in crystal always shows up in GMT time when I want it to show up in Centra Time. Is there something I can do to a database view that will not only take the time zone into account but also dayling savings? For example, I can do the following to a view...but I have to change it when daylight savings goes into account.
V_SERVICE_CALL.ACTUALFINISH + CAST(- 6.0 AS DECIMAL) / 24 AS created,