"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/storage/column/datetime/32bit/r/2038.result" (6 Jun 2022, 555 Bytes) of package /linux/misc/mroonga-12.04.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 DROP TABLE IF EXISTS diaries;
    2 CREATE TABLE diaries (
    3 id INT PRIMARY KEY AUTO_INCREMENT,
    4 title TEXT,
    5 created_at DATETIME
    6 ) DEFAULT CHARSET UTF8MB4;
    7 INSERT INTO diaries (title, created_at)
    8 VALUES ('2038-01-18 03:14:07', '2038-01-18 03:14:07');
    9 INSERT INTO diaries (title, created_at)
   10 VALUES ('2038-01-20 03:14:08', '2038-01-20 03:14:08');
   11 Warnings:
   12 Warning	1265	Data truncated for column 'created_at' at row 1
   13 SELECT * FROM diaries;
   14 id	title	created_at
   15 1	2038-01-18 03:14:07	2038-01-18 03:14:07
   16 2	2038-01-20 03:14:08	1970-01-01 00:00:00
   17 DROP TABLE diaries;