smalldatetime in sql
The SMALLDATETIME data type specifies a date and time of day in SQL Server. SMALLDATETIME supports dates from 1900-01-01 through 2079-06-06. The default value is 1900-01-01 00:00:00. The seconds are always set to 0, and fractional seconds are not included.
SQL SMALLDATETIME Data Type
-- The SMALLDATETIME data type specifies a date and time of day in SQL Server. -- SMALLDATETIME supports dates from 1900-01-01 through 2079-06-06. -- The default value is 1900-01-01 00:00:00. --The seconds are always set to 0, and fractional seconds are not included. -- EXAMPLE CREATE TABLE DemoTable ( Id INT IDENTITY, ProductName VARCHAR(100) NOT NULL, RestockDate SMALLDATETIME ); GO INSERT INTO DemoTable VALUES ('Lays Chips', '2021-02-15 9:55:12'); INSERT INTO DemoTable VALUES ('Quaker Oats', '2021/11/08 8AM'); INSERT INTO DemoTable VALUES ('Oreo Cookies', '2021-05-14 13:12'); INSERT INTO DemoTable VALUES ('Fritos', '2021-9-2'); INSERT INTO DemoTable VALUES ('Cheetos', NULL); GO SELECT * FROM DemoTable; GO DROP TABLE DemoTable; GO Results: 5 records ID PRODUCTNAME RESTOCKDATE 1 Lays Potato Chips 2021-02-15 09:55:00 2 Quaker Oats 2021-11-08 08:00:00 3 Oreo Cookies 2021-05-14 13:12:00 4 Fritos 2021-09-02 00:00:00 5 Cheetos NULL -- Notice how SQL Server accepts different input date and time formats. -- These formats are converted to the internal format which is 'YYYY-MM-DD HH:MM:00'.
Source: www.dofactory.com