CREATE TABLE Time (
dataType VARCHAR (30) PRIMARY KEY,
Format VARCHAR (30),
Storage size bytes INTEGER
);
-- insert some values
INSERT INTO Time VALUES ('date', 'YYYY-MM-DD', '3');
INSERT INTO Time VALUES ('smalldatetime', 'YYYY-MM-DD hh:mm:ss', '4');
INSERT INTO Time VALUES ('datetime', 'YYYY-MM-DD hh:mm:ss[.nnn]', '8');
INSERT INTO Time VALUES ('datetime2', 'YYYY-MM-DD hh:mm:ss[.nnnnnnn]', '');
-- fetch some values
SELECT * FROM Time
To embed this project on your website, copy the following code and paste it into your website's HTML: