Guest Posted December 22, 2002 Share Posted December 22, 2002 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 -_- Link to comment Share on other sites More sharing options...
baonguyenx Posted December 22, 2002 Share Posted December 22, 2002 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 Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2002 Share Posted December 22, 2002 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 Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2002 Share Posted December 22, 2002 is there anyway just to set an offset value to adjust the time to NZ time? Link to comment Share on other sites More sharing options...
baonguyenx Posted December 22, 2002 Share Posted December 22, 2002 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 Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2002 Share Posted December 22, 2002 unfortunetly i dont have access to my mysqld? Link to comment Share on other sites More sharing options...
Guest Posted December 22, 2002 Share Posted December 22, 2002 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 Link to comment Share on other sites More sharing options...
Guest Posted December 26, 2002 Share Posted December 26, 2002 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!! Link to comment Share on other sites More sharing options...
gevans Posted December 27, 2002 Share Posted December 27, 2002 On my server it seems that setting the timezone in my .cshrc file works. setenv TZ EST Link to comment Share on other sites More sharing options...
WayneD Posted July 9, 2011 Share Posted July 9, 2011 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 Link to comment Share on other sites More sharing options...
WayneD Posted July 9, 2011 Share Posted July 9, 2011 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.