Breaking News: Grepper is joining You.com. Read the official announcement!

SQL SMALLDATETIME Data Type

Holy answered on July 21, 2022 Popularity 8/10 Helpfulness 2/10

answer SQL SMALLDATETIME Data Type

related smalldatetime in sql

SQL SMALLDATETIME Data Type

Comment

-- 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'.

Popularity 8/10 Helpfulness 2/10 Language sql

Source: www.dofactory.com

Tags: smalldatetime sql

Link to this answer
Share Copy Link

Contributed on Jul 21 2022

Holy

0 Answers Avg Quality 2/10

Closely Related Answers

smalldatetime in sql

Comment

-1

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.

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql smalldatetime smalldatetim

Link to this answer
Share Copy Link

Contributed on Jul 25 2022

Open Octopus

0 Answers Avg Quality 2/10

SQL SMALLDATETIME Data Type

Contents

More Related Answers

SQL SMALLDATETIME Data Type

Closely Related Answers

smalldatetime in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.