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

[Bryan Holladay]

You should probably be running 2.8.1 since there have been a ton of
bug fixes with issues reported in 2.8.0 (some about timezones like
https://jira.sakaiproject.org/browse/SAK-21111).  Also, the
announcements tool had lots of resolved issues in 2.8.1.

> We want to change database timezone,

Not sure if you need to change it in the DB when you can just set it
in the JavaOpts like:

JAVA_OPTS="-Dhttp.agent=Sakai  -Duser.timezone=America/Los_Angeles ...."


> what tools can effect?.

Calendar is the big one.  Every tool that uses a timestamp
(assignments, GB, T&Q, Forums.....) all will (and should) use the
Timezone.


>Is there any risk involved while changing database timezone.

Sakai handles timezones rather well...  We have several clients that
run in different time zones from the same datacenter.


Thanks,
Bryan

On Wed, Mar 28, 2012 at 4:20 AM, Jehan Badshah <jehan.badshah at nu.edu.pk> wrote:
> Dear All
>
> we are using sakai 2.8.0 and Oracle 9i.
>
> We want to change database timezone,
>
> what tools can effect?.
>
> Is there any risk involved while changing database timezone.
>
>
> Regards
> ----------------------------------------------------
> Jehan Badshah | Sr. Software Engineer
> FAST - National University of Computer and Emerging Sciences
> A.K. Brohi Road, H-11/4, Islamabad
> UAN: +92 (0)51 - 111 128 128 ext 344
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"