Date Functions
Introduction To Date Functions In SQL
Introduction:
In this article, you will learn what Date Functions are in SQL?
SQL Date function is used to hold the date. Each database includes many schemes for the data and in RDBMS, each record has many date functions. All syntax of the functions are unique for the database, when the function is called.
The Datepart Function
Datepart function returns the area of DateTime field.
Syntax
The basic syntax for "Datepart" date function is as follows:
DATEPART ([Date part], [Datetime])
We can use some data type for DateTime function in SQL Server database. These data types are as follows:
|
Description |
Value |
|---|---|
|
Quarter interval |
quarter, qq, q |
|
Month interval |
month, mm, m |
|
Day of year interval |
dayofyear |
|
Year interval |
year, yyyy, yy |
|
Day interval |
day, dy, y |
|
Week interval |
week, dw, w |
|
Weekday interval |
weekday, ww, wk |
|
Hour interval |
hour, hh |
|
Minute interval |
minute, mi, n |
|
Second interval |
second, ss, s |
|
Millisecond interval |
millisecond, ms |
- DATEADD()
- DATEDIFF()
- DATENAME()
- DATEPART()
- DAY()
- GETDATE()
- MONTH()
- YEAR()
DATEADD()
DATEADD() function is used to add or subtract the date-time. It gives a new date-time, based on add or subtract interval.
DATEDIFF()
DATEDIFF() function is used to find the difference between the two days.
DATENAME()
DATENAME() function is used to find the name with the help of DateTime value.
DATEPART()
DATEPART() function is used to divide the date or time.
Day()
Day() function is used to find the day from any DateTime value.
GETDATE()
GATEDATE() function returns the date and time of the system and it does not contain any parameter.
MONTH()
MONTH() function is used to find the month from any DateTime value.
YEAR
YEAR function is used to find the year from any DateTime value.
Summary:
Thus, we learnt, date function command holds the date in SQL.
CONTRIBUTE
MOBILE APP
