[Building Sakai] Is there any risk involved while changing database timezone

[Bryan Holladay]

On Wed, Mar 28, 2012 at 1:12 PM, Jehan Badshah <jehan.badshah at nu.edu.pk> wrote:
>
> Dear  Bryan
>
> Thanks for reply, I set JAVA_OPTS parameter to my local timezone as
>  -Duser.timezone='Asia/Karachi'
>
> then restarted tomcat,
>
> now sakai/tomcat log showing GMT+0 time, but I am on GMT+5
> (e.g., Asia/Karachi)
>

It sounds like you have 2 timezones offsetting each other, which might
explain the GMT +0

>
> when I am running following query
> select DBTIMEZONE,to_char(current_timestamp, 'dd Mon yy hh24:mi:ss TZD')
> from dual;
> it showing following time, which is different from my country time.
> -07:00 28 Mar 12 05:50:22
>

That has nothing to do with the JAVAOPTS setting.  It's your DB
timezone setting.

> same time also showing in some places, like time of cron job, and turnitin.
>
> we want to sych time zone and time of all machines and database of our
> deployment.
>
>

Maybe someone else with more experience dealing w/timezones in Sakai
has a better idea?


-Bryan