|
1
by brian
clean slate |
1 |
drop table if exists t1;
|
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
2 |
create table t1 (Tag int not null, Monat int not null,
|
|
776
by Brian Aker
func_timestamp now working. |
3 |
Jahr int not null, index(Tag), index(Monat), index(Jahr) );
|
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
4 |
insert into t1 values (16,9,1998),(16,9,1998);
|
5 |
SELECT CONCAT(Jahr,'-',Monat,'-',Tag) AS Date,
|
|
6 |
UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag)) AS Unix
|
|
|
1
by brian
clean slate |
7 |
FROM t1;
|
8 |
Date Unix
|
|
|
907.1.7
by Jay Pipes
Merged in remove-timezone work |
9 |
1998-9-16 905904000
|
10 |
1998-9-16 905904000
|
|
|
1
by brian
clean slate |
11 |
drop table t1;
|