DATE() function issue

[Oleksii Puzyr]

Hi all,

Using embedded 10.10.1.1:

CREATE TABLE TEST
(
    ID INT NOT NULL,
    DATE TIMESTAMP NOT NULL
);

insert into test(id, date) values (1,'1988-12-25 18:00:34');
select date(date),date from test;

Result:
'1988-12-24',   '1988-12-25 17:00:34'

Please explain why date() result is not as expected (I expect it to be 
'1988-12-25') and timestamp is one hour before?

Thanks.