Wrong time for the Time Zone sellected

smic717394 · **Joined:** Sun Apr 17, 2005 12:00 am **Posts:** 106

Hi,

I have selected in the configuration as time zone, Europe/London GMT +0, Country: UK and zone: London, but on the time stamp on the order is still the server time.

For example, an order placed around 00:10 it shows in the order details as 18:03 which I think is the Eastern Standard Time.

What I'm doing wrong here.

soundzgood2 · **Posted:** Fri Mar 12, 2010 7:20 am

Hi smic

The config setting on the database won't change a server date/time stamp (I guess you've confirmed this in Admin->Tools->Server Info ... Server Date vs Database Date).

Why not get hosted locally? There's some pretty cheap deals in the UK and you get local support.

Simon

smic717394 wrote:

Hi,

I have selected in the configuration as time zone, Europe/London GMT +0, Country: UK and zone: London, but on the time stamp on the order is still the server time.

For example, an order placed around 00:10 it shows in the order details as 18:03 which I think is the Eastern Standard Time.

What I'm doing wrong here.

smic717394 · **Joined:** Sun Apr 17, 2005 12:00 am **Posts:** 106

I found a solution for now.
In admin/includes/languages/englis.php ~line 75 and after includes/languages/englis.php ~line 32 after:

Code:

define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

i added:

Code:

date_default_timezone_set('Europe/London');

and because i have spanish language as well, in admin/includes/languages/espanol.php ~line 76 and after includes/languages/espanol.php ~line 20 after:

Code:

@setlocale(LC_TIME, 'Spanish');

I added:

Code:

date_default_timezone_set('Europe/Madrid');

I dont know whether to use date_default_timezone_set or PUTENV, or if is the correct way, i dont want to have other problem for using this function.

In admin/includes/configure.php and /includes/configure.php in the ens i've added the line bellow:

Code:

define('CONFIG_TIME_ZONE', '+00:00');

in admin/includes/functions/database.php and /includes/functions/database.php ~ line 22 changed:

Code:

if ($$link) mysql_select_db($database);

with

Code:

 if ($$link) { 
      mysql_select_db($database);
      tep_db_query('SET time_zone=\'' . CONFIG_TIME_ZONE . '\''); 
    }

CRE Loaded Community

Wrong time for the Time Zone sellected

Who is online

Main Menu

Login

Top Listing

Members Online

Follow Us on Twitter

CRE Loaded Community Chat hosted by CRE Loaded.