timezone.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- DROP TABLE IF EXISTS t1;
- show variables like "system_time_zone";
- Variable_name Value
- system_time_zone MET
- select @a:=FROM_UNIXTIME(1);
- @a:=FROM_UNIXTIME(1)
- 1970-01-01 01:00:01
- select unix_timestamp(@a);
- unix_timestamp(@a)
- 1
- CREATE TABLE t1 (ts int);
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 03:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 02:59:59'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:00:00'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:59:59'));
- INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
- SELECT ts,from_unixtime(ts) FROM t1;
- ts from_unixtime(ts)
- 1035673200 2002-10-27 01:00:00
- 1035680400 2002-10-27 02:00:00
- 1035684000 2002-10-27 03:00:00
- 1035680400 2002-10-27 02:00:00
- 1035673200 2002-10-27 01:00:00
- 1035680400 2002-10-27 02:00:00
- 1048986000 2003-03-30 03:00:00
- 1048986000 2003-03-30 03:00:00
- 1048989599 2003-03-30 03:59:59
- 1048989601 2003-03-30 04:00:01
- DROP TABLE t1;
- CREATE TABLE t1 (ts timestamp);
- INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
- ('2003-03-30 02:59:59'),
- ('2003-03-30 03:00:00');
- Warnings:
- Warning 1299 Invalid TIMESTAMP value in column 'ts' at row 2
- DROP TABLE t1;
- select unix_timestamp('1970-01-01 01:00:00'),
- unix_timestamp('1970-01-01 01:00:01'),
- unix_timestamp('2038-01-01 00:59:59'),
- unix_timestamp('2038-01-01 01:00:00');
- unix_timestamp('1970-01-01 01:00:00') unix_timestamp('1970-01-01 01:00:01') unix_timestamp('2038-01-01 00:59:59') unix_timestamp('2038-01-01 01:00:00')
- 0 1 2145916799 0