DATEFROMPARTS() Function in SQL Server
DATEFROMPARTS() function :
This function in SQL Server is used to return a date from the given values of year, month and day.
Features :
- This function is used to find a date from the stated values of year, month and day.
- This function comes under Date Functions.
- This function accepts three parameters namely year, month and day.
- This function cannot include any time with the stated date.
Syntax :
DATEFROMPARTS(year, month, day)
Parameter :
This method accepts three parameters as given below :
- year : It is the year specified which is of 4 digits.
- month : It is the month specified which is from 1 to 12.
- day : It is the day specified which is from 1st to 31st.
Returns :
It returns a date from the given values of year, month and day.
Example-1 :
Using DATEFROMPARTS() function and getting the date specified.
SELECT DATEFROMPARTS(2021, 01, 04);
Output :
2021-01-04
Example-2 :
Using DATEFROMPARTS() function with a variable and getting the date specified.
DECLARE @year Int; SET @year = 2012; SELECT DATEFROMPARTS(@year, 09, 13);
Output :
2012-09-13
Example-3 :
Using DATEFROMPARTS() function with three variables and getting the date specified.
DECLARE @year Int; DECLARE @month Int; DECLARE @day Int; SET @year = 2016; SET @month = 08; SET @day = 29; SELECT DATEFROMPARTS(@year, @month, @day);
Output :
2016-08-29
Example-4 :
Using DATEFROMPARTS() as a default value in the below example and getting the output.
CREATE TABLE date_from_parts ( id_num INT IDENTITY, message VARCHAR(150) NOT NULL, generated_at DATETIME NOT NULL DEFAULT DATEFROMPARTS(2001, 4, 7), PRIMARY KEY(id_num) ); INSERT INTO date_from_parts(message) VALUES('First Message'); INSERT INTO date_from_parts(message) VALUES('date_from_parts'); SELECT id_num, message, generated_at FROM date_from_parts;
Output :
S.No. | id_num | message | generated_at |
---|---|---|---|
1 | 1 | First Message | 07.04.2001 00:00:00 |
2 | 2 | date_from_parts | 07.04.2001 00:00:00 |
Here, firstly you need to create a table then insert values into it then generate the required output using DATEFROMPARTS() function as a default value.
Note : For running above code use sql server compiler, you can also use a online compiler.
Application :
This function is used to find the date from the specified values year, month and day.
Contact Us