Date
Functions
In SQL Server
Email [email protected]
02
Important Date Functions
GETDATE( )
DATEPART(
DATEADD(
DATEDIFF(
DATENAME()
03
IMPORTANT DATE FUNCTIONS
GETDATE( )
It Returns the current date and time from the
SQL server.
SELECT GETDATE( )
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
04
IMPORTANT DATE FUNCTIONS
DATEPART( )
It is used to return a single part of a date/time,
such as year, month, day, etc.
SELECT DATEPART(datepart,date)
SELECT DATEPART(yy,'2024-01-25 12:11:09')
SELECT DATEPART(qq,'2024-07-25 12:11:09')
SELECT DATEPART(mm,'2024-06-25 12:11:09')
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
05
IMPORTANT DATE FUNCTIONS
DATEPART( )
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
06
DATEPART YOU CAN USE
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
07
IMPORTANT DATE FUNCTIONS
DATEADD( )
It is used to add and subtract date you read it
right it can also subtract date.
SELECT DATEADD(datepart,number,date)
SELECT DATEADD(yy, 2, '2024-01-25 12:11:09')
SELECT DATEADD(qq, 2, '2024-07-25 12:11:09')
SELECT DATEADD(mm, -3, '2024-06-25 12:11:09')
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
08
IMPORTANT DATE FUNCTIONS
DATEADD( )
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
09
IMPORTANT DATE FUNCTIONS
DATEDIFF( )
It is used find difference between two dates
according to your datepart.
SELECT DATEDIFF(datepart,start_date,end_date)
SELECT DATEDIFF(yy,'2020-01-25','2024-01-25')
SELECT DATEDIFF(dd,'2023-01-25','2023-02-25')
SELECT DATEDIFF(mm,'2023-01-25','2023-06-25')
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
10
IMPORTANT DATE FUNCTIONS
DATEDIFF( )
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
11
IMPORTANT DATE FUNCTIONS
DATENAME( )
It is used to retrieve a specified part of a date,
such as the day, month, or year.
SELECT DATENAME(datepart,date)
SELECT DATENAME(MONTH, '2023-01-25')
LinkedIn www.linkedin.com/in/dhruvik-detroja/ Email [email protected]
For More Education Content
FOLLOW
ME ON
LINKEDIN
LinkedIn www.linkedin.com/in/dhruvik-detroja/
