DatePart, DateAdd and DateDiff functions in SQL Server Part 27

Yep that was hardest video up to now. Took me long to understand literally

Bravo!! Well Done!

In the last 10 mins is boring and confusing it seems un necessary topic in last 10 minutes.

Hi, do you have any idea or video where you can show us how to use a function "same period last year"if that exist in SQL, in order to get a a value and compare to the last year. thanks and regards.

please do a python video

What is the datatype of column DateOfBirth in that table.tblEmployees, is it date time?

select dateadd(yyyy,2010-1900,0) means why we use 1900 for what purpose
pls give answer about that

How about this query?

declare @d1 date = '2010-12-31', @d2 date = '2011-01-01';
declare @ds int = datediff(day, @d1, @d2);
select @ds/365 as years, (@ds%365)/12 as months, @ds%12 days;

logic is quite complicated 😀

Hi.. can you help me to find out continuously absent check in sql query in two or more table using date & time. my mail add is itkaushik@outlook.com

Outstanding !!! Your tutorial is really easy to understand, digest and develop a carrer.. Thank you

CREATE FUNCTION FN_CountAge(@DOB DATETIME)
RETURNS NVARCHAR(50)
AS
BEGIN
DECLARE @TEMPDATE DATETIME , @YEAR INT , @MONTH INT , @DAY INT

SELECT @TEMPDATE = @DOB

SELECT @YEAR = DATEDIFF(YEAR,@TEMPDATE,GETDATE()) –
CASE WHEN DATEPART(MONTH,@DOB) > DATEPART (MONTH,GETDATE())
OR DATEPART(MONTH,@DOB) = DATEPART(MONTH,GETDATE())
AND DATEPART(DAY,@DOB) = DATEPART(DAY,GETDATE()) THEN 1 ELSE 0 END
SELECT @TEMPDATE = DATEADD(YEAR,@YEAR,@TEMPDATE)
SELECT @MONTH = DATEDIFF(MONTH,@TEMPDATE,GETDATE()) –
CASE
WHEN DATEPART(DAY,@DOB) > DATEPART(DAY,GETDATE())
THEN 1 ELSE 0 END
SELECT @TEMPDATE = DATEADD(MONTH,@MONTH,@TEMPDATE)
SELECT @DAY = DATEDIFF(DAY,@TEMPDATE,GETDATE())

DECLARE @AGE NVARCHAR(50)
SET @AGE = CAST( @YEAR AS nvarchar(4)) +' Years '+ cast( @MONTH as nvarchar(4))+' Months '+ cast( @DAY as nvarchar(4))+' Days Old'
RETURN @AGE
END

Hi venkat.
You are great teacher.
I learnt from your tutorials alot.
I have your all tutorials. C sharp sql asp mvc entity framework javascript bootstrap and much more.
I love you so much.

Hello Venkat,

I have database ,Date_Time , ProcessVal1, ProcessVal2, ProcessVal3 . I want to filter out data by minute and Hourly .
For report generation function. Can you please let me know . How i can do this.

Vankat thank you despite the fact you wrote this 5 years ago and I'm a bit late you deserve congratulations and thanks for this lesson and this series, Raph.

If you have problems understanding the DATEDIFF, keep in mind these four things:
1) It returns as integer.
2) It counts how many times you have to cross a line (from one year to another etc.)
3) It doesn't care about greater accuracy than you pass in as the first parameter. Year 2017 is year 2017, no matter whether it is January first or December 31st. So between 1.1.2017 and 31.12.2017 you are in the same year, datediff in years is zero, because you are essentially passing as parameters XX.XX.2017 and XX.XX.2017. And from 31.12.2016 to 1.1.2018 you have to cross two lines (to 2017 and then to 2018), the datediff returns two.
4) The +/- mark just tells whether you are going forward or backwards in time.

At least for me it took a while to understand the function, but with these four points, I think it should become pretty simple.

EVEN THOUGH YOUR TUTORIALS ARE STILL VERY MUCH THE BEST

Brief and outstanding THANK YOU

Wonderful job!