create table xxxDate.sql

create table xxxDate(ts TIMESTAMP NOT NULL, dt DATETIME NOT NULL);

insert times.sql

insert into xxxDate values('2012-06-10 15:08:05', '2012-06-10 15:08:05');
insert into xxxDate values('2012-12-10 15:08:05', '2012-12-10 15:08:05');

select dates from London-1.sql

set time_zone='Europe/London';
select * from xxxDate;
+---------------------+---------------------+
| ts                  | dt                  |
+---------------------+---------------------+
| 2012-06-10 12:08:05 | 2012-06-10 15:08:05 |
| 2012-12-10 11:08:05 | 2012-12-10 15:08:05 |
+---------------------+---------------------+

select dates from London-2.sql

select UNIX_TIMESTAMP(ts), UNIX_TIMESTAMP(dt) from xxxDate;
+--------------------+--------------------+
| UNIX_TIMESTAMP(ts) | UNIX_TIMESTAMP(dt) |
+--------------------+--------------------+
|         1339326485 |         1339337285 | // 14h (dt)
|         1355137685 |         1355152085 | // 15h (dt)
+--------------------+--------------------+

select dates from Moscow.sql

select * from xxxDate;
+---------------------+---------------------+
| ts                  | dt                  |
+---------------------+---------------------+
| 2012-06-10 15:08:05 | 2012-06-10 15:08:05 |
| 2012-12-10 15:08:05 | 2012-12-10 15:08:05 |
+---------------------+---------------------+
select UNIX_TIMESTAMP(ts), UNIX_TIMESTAMP(dt) from xxxDate;
+--------------------+--------------------+
| UNIX_TIMESTAMP(ts) | UNIX_TIMESTAMP(dt) |
+--------------------+--------------------+
|         1339326485 |         1339326485 |
|         1355137685 |         1355137685 |
+--------------------+--------------------+

set Moscow time zone.sql

set time_zone='Europe/Moscow';