mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
43 lines
1.2 KiB
Plaintext
43 lines
1.2 KiB
Plaintext
DROP DATABASE IF EXISTS mcs274_db;
|
|
CREATE DATABASE mcs274_db;
|
|
USE mcs274_db;
|
|
CREATE TABLE t1
|
|
(
|
|
t1_DATE DATE,
|
|
t1_TIME TIME,
|
|
t1_DATETIME DATETIME
|
|
)ENGINE=Columnstore;
|
|
INSERT INTO t1 VALUES('1560-08-27', '22:12:02', '1997-12-12 22:12:02');
|
|
INSERT INTO t1 VALUES('1982-02-19', '23:59:59', '2001-1-1 23:59:59.65');
|
|
INSERT INTO t1 VALUES('3291-05-30', '01:37:50.871', '09-12-11 01:08:59');
|
|
SELECT TIME('112233') FROM t1 LIMIT 1;
|
|
TIME('112233')
|
|
11:22:33
|
|
SELECT TIME('11:22:33.4455') FROM t1 LIMIT 1;
|
|
TIME('11:22:33.4455')
|
|
11:22:33.4455
|
|
SELECT TIME('1811/2/2 3:34:45.5') FROM t1 LIMIT 1;
|
|
TIME('1811/2/2 3:34:45.5')
|
|
03:34:45.5
|
|
SELECT TIME('1811/2/2') FROM t1 LIMIT 1;
|
|
TIME('1811/2/2')
|
|
00:18:11
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect time value: '1811/2/2'
|
|
SELECT t1_DATE, TIME(t1_DATE) FROM t1 ORDER BY 1;
|
|
t1_DATE TIME(t1_DATE)
|
|
1560-08-27 NULL
|
|
1982-02-19 NULL
|
|
3291-05-30 NULL
|
|
SELECT t1_TIME, TIME(t1_TIME) FROM t1 ORDER BY 1;
|
|
t1_TIME TIME(t1_TIME)
|
|
01:37:50 01:37:50
|
|
22:12:02 22:12:02
|
|
23:59:59 23:59:59
|
|
SELECT t1_DATETIME, TIME(t1_DATETIME) FROM t1 ORDER BY 1;
|
|
t1_DATETIME TIME(t1_DATETIME)
|
|
1997-12-12 22:12:02 22:12:02
|
|
2001-01-01 23:59:59 23:59:59
|
|
2009-12-11 01:08:59 01:08:59
|
|
DROP DATABASE mcs274_db;
|