Setting order time to NZ time zone

[Guest]

within the admin area, the order time are displayed as the server local time *server locates in USA*

 

is there anyway to modify this to display the time in New Zealand? which is GMT+12

 

really struggling with this -_-

[baonguyenx]

Hi,

 

You need to modify that mysql boot up file /etc/rc.d/init.d/mysqld

 

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &

change to

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --timezone=GMT+12 &

 

Regards,

Bn

[Guest]

didnt really understand that, nor am i sure i can get access to that?

 

i have SSH shell login access, but i cannot modify the date using date -s blahblah

 

 

can you explain it further? sorry i am new to all these

[Guest]

is there anyway just to set an offset value to adjust the time to NZ time?

[baonguyenx]

Hi,

 

You need to modify mysql boot up file /etc/rc.d/init.d/mysqld

 

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &

change to

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --timezone=GMT+12 &

 

By adding --timezone=GMT+12 , mysql database will change the time to your local time. After you modify that file, restart mysql and date and timestamp fields will refect this change or you can run a query "select now();" to see its change.

 

To restart mysql database:

/etc/rc.d/init.d/mysqld restart

 

Regards,

Bn

[Guest]

unfortunetly i dont have access to my mysqld?

[Guest]

problem fixed with a temporary solution, pm me if you are also struggling with the order time

 

i be more than happy to help out

[Guest]

You need to modify that mysql boot up file /etc/rc.d/init.d/mysqld

Most probably iijan has a shared server, meaning that s/he won't be able to modify anything outside of the assigned webroot. I know that is the case with one of the hosting accounts that I possess where the server is hosted in america. Therefore, modifying *any* configuration files is not going to happen. A change of this nature (changing MySQL's timezone) would affect all of the users of the server, and I would presume that most of them wouldn't be in NZ.

 

in all reality, the timezone is probably set to UTC/GMT. This makes calculations a little easier. Maybe a modification to one of the tep_date_* functions would make this possible!!

[gevans]

On my server it seems that setting the timezone in my .cshrc file works.

 

setenv TZ EST

[WayneD]

problem fixed with a temporary solution, pm me if you are also struggling with the order time

 

i be more than happy to help out

[WayneD]

problem fixed with a temporary solution, pm me if you are also struggling with the order time

 

i be more than happy to help out

 

 

 

Hey, Im in NZ and also having problems changing the time zone from the US. PLEASE HELP!