2
# Tests that depend on the timestamp and the TZ variable
6
drop table if exists t1;
9
# Set timezone to GMT-3, to make it possible to use "interval 3 hour"
10
create table t1 (Tag int not null, Monat int not null,
11
Jahr int not null, index(Tag), index(Monat), index(Jahr) );
12
insert into t1 values (16,9,1998),(16,9,1998);
13
SELECT CONCAT(Jahr,'-',Monat,'-',Tag) AS Date,
14
UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag)) AS Unix