|
642.1.41
by Lee
enable warnings test and fix timezone test to comment out the failing test |
1 |
FROM_UNIXTIME(24*3600)
|
|
907.1.7
by Jay Pipes
Merged in remove-timezone work |
2 |
1970-01-02 00:00:00
|
|
1
by brian
clean slate |
3 |
DROP TABLE IF EXISTS t1;
|
4 |
select @a:=FROM_UNIXTIME(1);
|
|
5 |
@a:=FROM_UNIXTIME(1)
|
|
|
907.1.7
by Jay Pipes
Merged in remove-timezone work |
6 |
1970-01-01 00:00:01
|
|
1
by brian
clean slate |
7 |
select unix_timestamp(@a);
|
8 |
unix_timestamp(@a)
|
|
9 |
1
|
|
10 |
CREATE TABLE t1 (ts int);
|
|
11 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
|
|
12 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
|
|
13 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 03:00'));
|
|
14 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
|
|
15 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
|
|
16 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
|
|
17 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 02:59:59'));
|
|
18 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:00:00'));
|
|
19 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:59:59'));
|
|
20 |
INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
|
|
21 |
SELECT ts,from_unixtime(ts) FROM t1;
|
|
22 |
ts from_unixtime(ts)
|
|
|
907.1.7
by Jay Pipes
Merged in remove-timezone work |
23 |
1035680400 2002-10-27 01:00:00
|
24 |
1035684000 2002-10-27 02:00:00
|
|
25 |
1035687600 2002-10-27 03:00:00
|
|
26 |
1035684000 2002-10-27 02:00:00
|
|
27 |
1035680400 2002-10-27 01:00:00
|
|
28 |
1035684000 2002-10-27 02:00:00
|
|
29 |
1048993199 2003-03-30 02:59:59
|
|
30 |
1048993200 2003-03-30 03:00:00
|
|
31 |
1048996799 2003-03-30 03:59:59
|
|
32 |
1048996801 2003-03-30 04:00:01
|
|
|
1
by brian
clean slate |
33 |
DROP TABLE t1;
|
34 |
CREATE TABLE t1 (ts timestamp);
|
|
35 |
INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
|
|
36 |
('2003-03-30 03:00:00');
|
|
37 |
DROP TABLE t1;
|
|
|
907.1.7
by Jay Pipes
Merged in remove-timezone work |
38 |
select unix_timestamp('1970-01-01 00:00:00');
|
39 |
unix_timestamp('1970-01-01 00:00:00')
|
|
40 |
0
|
|
41 |
select unix_timestamp('1970-01-01 00:00:01');
|
|
42 |
unix_timestamp('1970-01-01 00:00:01')
|
|
43 |
1
|
|
44 |
select unix_timestamp('2038-01-19 03:14:07');
|
|
45 |
unix_timestamp('2038-01-19 03:14:07')
|
|
46 |
2147483647
|
|
47 |
select unix_timestamp('2038-01-19 03:14:08');
|
|
48 |
ERROR HY000: Received an invalid value '2038-01-19 03:14:08' for a UNIX timestamp.
|