Date formatting in SQL SERVER, using 2 functions

Date formatting in SQL SERVER, and instructions for using GETDATE() and CONVERT() functions.

Date formatting in SQL SERVER

• 1. date and datetime Type difference
• 2. GETDATE () function, return the current date and time (datetime type)
• 3. CONVERT () function, format the date

1. The difference between date and datetime types
Date is the new data type introduced in SQL Server 2008. It represents a date, does not contain a time part, and can represent a date range from January 1, 1999 to December 31, 9999. Only 3 bytes of storage are required.

dateTime date and time part, can represent the date range from 00:00:00.000 on January 1, 1753 to 23:59:59.997 on December 31, 9999, accurate to 3.33 milliseconds, it requires 8 bytes of storage space.

GETDATE () function

return the current date and time (datetime type)
SELECT GETDATE();
return
2017-03-16 09:10:08.947
For example, create a form M

CREATE TABLE [dbo].[M](
    [id] [int] NULL,
    [date] [date] NULL,
    [time] [datetime] NULL
) ON [PRIMARY]

You can insert data using the GETDATE() function

INSERT INTO M(id, date, time) VALUES (1, CONVERT(VARCHAR, GETDATE(), 110), GETDATE());

3. CONVERT () function, format the date
The CONVERT() function is a generic function that converts dates to new data types, and can also display date/time data in different formats.

grammar:

CONVERT(data_type(length),date,style)

• Data_type(length) specifies the target data type (with optional length). Date refers to the value that needs to be converted. Style Specifies the date/time output format.
• Style value that can be used: current time January 3, 2017 09:09:10:037

Date formatting in SQL SERVER, and instructions for using GETDATE() and CONVERT() functions.