📄 timezone3.result
字号:
drop table if exists t1;create table t1 (i int, c varchar(20));insert into t1 values(unix_timestamp("2004-01-01 00:00:00"), "2004-01-01 00:00:00");insert into t1 values(unix_timestamp("2004-03-28 01:59:59"), "2004-03-28 01:59:59"),(unix_timestamp("2004-03-28 02:30:00"), "2004-03-28 02:30:00"),(unix_timestamp("2004-03-28 03:00:00"), "2004-03-28 03:00:00");insert into t1 values(unix_timestamp('2004-05-01 00:00:00'),'2004-05-01 00:00:00');insert into t1 values(unix_timestamp('2004-10-31 01:00:00'),'2004-10-31 01:00:00'),(unix_timestamp('2004-10-31 02:00:00'),'2004-10-31 02:00:00'),(unix_timestamp('2004-10-31 02:59:59'),'2004-10-31 02:59:59'),(unix_timestamp('2004-10-31 04:00:00'),'2004-10-31 04:00:00'),(unix_timestamp('2004-10-31 02:59:59'),'2004-10-31 02:59:59');insert into t1 values(unix_timestamp('1981-07-01 03:59:59'),'1981-07-01 03:59:59'),(unix_timestamp('1981-07-01 04:00:00'),'1981-07-01 04:00:00');select i, from_unixtime(i), c from t1;i from_unixtime(i) c1072904422 2004-01-01 00:00:00 2004-01-01 00:00:001080428421 2004-03-28 01:59:59 2004-03-28 01:59:591080428422 2004-03-28 03:00:00 2004-03-28 02:30:001080428422 2004-03-28 03:00:00 2004-03-28 03:00:001083355222 2004-05-01 00:00:00 2004-05-01 00:00:001099170022 2004-10-31 01:00:00 2004-10-31 01:00:001099177222 2004-10-31 02:00:00 2004-10-31 02:00:001099180821 2004-10-31 02:59:59 2004-10-31 02:59:591099184422 2004-10-31 04:00:00 2004-10-31 04:00:001099180821 2004-10-31 02:59:59 2004-10-31 02:59:59362793608 1981-07-01 03:59:59 1981-07-01 03:59:59362793610 1981-07-01 04:00:00 1981-07-01 04:00:00drop table t1;create table t1 (ts timestamp);insert into t1 values (19730101235900), (20040101235900);select * from t1;ts1973-01-01 23:59:002004-01-01 23:59:00drop table t1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -