db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oleksii Puzyr <opu...@gmail.com>
Subject DATE() function issue
Date Fri, 19 Apr 2013 17:43:40 GMT
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.
Mime
View raw message