SQL Tutorial - 45: Date & Time Functions (Part-1) Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the 45th tutorial in this course and in
this tutorial you're going to begin our
discussion on date and time functions
and in this one we are going to check
out four important date and time
functions the first one we're going to
have a look at is the add date function
and as the name of the function suggests
this function is used to add date values
right so I mean the syntax of the
function that we're going to check out
in this course
with this syntax you can add you know
given number of days or months or years
to a given date value right so I'll type
in select first and then the name of the
function which is add date I'll get in a
set of parentheses and within single
quotes I'll put in a date value and the
format the default format for typing in
date values in SQL is you type in the
ear first in four digits and then you
put a hyphen and then two digits for the
month so if it's July then you have to
put 0 7 instead of just 7 and then you
put another - and you then type in your
day right so if it's a 6 July then
you'll have to type in 0 7 - 0 6 right
so that's what you'd have to do so if I
have to get in the date let's say 20th
November 1989 I'll type in 1 9 8 9 first
put in - and then 11 for November and 28
and 24 the 28th day of the month right
then I'll put a comma and I'll type in
the keyword interval right and then
let's say I want to add 25 days to this
value so I'll type in 25 and then the
keyword day right so what you have to
note here is you don't have to write in
days but you have to write day right
I'll put a semicolon at the end and when
I execute this function I see that I get
the result 15 December 1989 so if you
add 25 days to this value then you get
this right and if you want to add 25
months instead all you have to do is
replace day with M o n th that's month
and again you don't have to type in
months but just month and execute the
function to get 20th December 1991 and
if you want to add let's say 25 years to
it then you type in
your instead of month there you go you
see that 25 years later this date would
become 20th November 2014 and similar to
this function is the sub date function
which is as you can guess used to
subtract values from a given date right
so I'll change this to day first and
I'll change the function name to sub
date from a date right so what we are
going to do now is find out you know if
you subtract 25 days from this day to
that what would be the value in the
result set and that would be 26th
October 1989 so 25 days ago this date
was 26th October 1989 if you want to
check out 25 months ago it was the value
the value was 20th October 1987 and you
can similarly check for year right so
the next function that we're going to
check out is the cur date function and
what the carded function is used for it
gives you the current date of the system
and what I mean by that is if you have
MySQL or for that matter any other our
DBMS installed on a system and if you
execute the current date function or the
cur time function then the values that
you get are the values you know that the
system is currently working with and
I'll just explain this so I'll type in
the name of the function called date and
I'll get in a set of parentheses put in
a semicolon so you have to note that you
don't have to pass anything to this
function as an argument you know you
just have to have an empty set of
parentheses when I execute the function
I get 15 January 2014 so that's today's
date and if you want to know the time
the current time then you have to
execute the function cur time and we see
that the time is 1 12 p.m. and 10
seconds it so it also tells the number
of seconds and if suppose I change the
date and time of my system so if suppose
I change the time to 1:30 2:00 p.m.
and execute this function now I see that
in the results said I get 132 so the
point that I am trying to make here is
that the time that this function returns
or the date that the current date
function returns you know those values
are the values with which your system is
working with and if you got your SQL
environment set up on a server then you
know whatever the date and time settings
of the server are you know those values
will be displayed you know when you
execute these functions and not the
actual values I mean you know this
function is not pulling out stuff from
the internet it's just returning
whatever your system is working with so
that's it for now I hope you guys are
having fun in the seas and in the next
tutorial we are going to check out some
more date and time functions thank you
so much for watching this one and you
may subscribe to my channel and I'll see
you soon