Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

SQL- Date Functions 

Pooja Goel  |   Nov 11, 2019  |  Views: 15

Description:

 

There are list of DATE Function which follows:

 

1) DATEADD() :

This function is used to add Date/Time Interval to Date.

 

Syntax : DATEADD(Interval date, valueDate)

Example : The following query will add 1 month to Input date.

 

SELECT DATEADD(Month, 1, '2019/11/11') AS Date

Output

 


2) DATEDIFF() :

This function is used to return difference between two dates.

 

Syntax : DATEDIFF(Interval, Start_dateEnd_Date)

Example : The following query will return no. of days between two Input dates.

 

SELECT DATEDIFF(Day, '2019/09/11', '2019/11/11') AS Date

Output

 

 

3) GETDATE() :

 This function is used to return current system date and time.

 

Syntax : GETDATE()

Example : The following query will return current date and time of system on which SQL is running.

 

SELECT GETDATE() AS Date

Output

 

 

4) DATEPART() :

This function is used to return date part of date as an Integer.

 

Syntax : DATEPART(IntervalInputdate)

Example : The following query will return year of date.

 

SELECT DATEPART(Year, '2019/09/11') AS Date

Output

 

 

5) DATENAME() :

This function is used to return date part of date as an String.

 

Syntax : DATENAME(IntervalInputdate)

Example : The following query will return month of date.

 

SELECT DATENAME(Month, '2019/09/11') AS Date

Output

 

 

6) CURRENT_TIMESTAMP :

This function is used to return date and time.

 

Syntax : CURRENT_TIMESTAMP

Example : The following query will return current date and time.

 

SELECT CURRENT_TIMESTAMP;

Output


 

7) DAY() :

This function is used to return days of date.

 

Syntax : DAY(InputDate)

Example : The following query will return days of date.

 

SELECT Day('2019/09/11') as Days

Output


 

8) MONTH :

 This function is used to return month of date.

 

Syntax : Month(InputDate)

Example : The following query will return month of date.

 

SELECT Month('2019/09/11')

Output

 



9) YEAR() :

This function is used to return year of date.

 

Syntax : YEAR(InputDate)

Example : The following query will return year of date.

 

SELECT YEAR('2019/09/11') 

Output

 


10) SYSDATETIME() :

This function is used to return date and time of Server.

 

Syntax : SYSDATETIME()

Example : The following query will return current date and time of server.

 

SELECT SYSDATETIME() AS SysDateTime;

Output


 

11) DATEFROMPARTS() :

This function is used to return date from specified parts.

 

Syntax : DATEFROMPARTS(year,month,day)

Example : The following query will return date.

 

SELECT DATEFROMPARTS(2019, 10, 11)

Output



Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Read related articles

SQL-CURSOR

Pooja Goel  |   Nov 16, 2019  |  Views: 13

SQL-Normalization

Pooja Goel  |   Nov 16, 2019  |  Views: 14

SQL-Injection

Pooja Goel  |   Nov 16, 2019  |  Views: 23

SQL-Convert/Cast Function

Pooja Goel  |   Nov 15, 2019  |  Views: 10

SQL-DENSE_RANK()

Pooja Goel  |   Nov 14, 2019  |  Views: 21

SQL-RANK()

Pooja Goel  |   Nov 14, 2019  |  Views: 9

SQL-Row_Number()

Pooja Goel  |   Nov 14, 2019  |  Views: 6

SQL-DATA TYPE

Pooja Goel  |   Nov 11, 2019  |  Views: 17

SQL-String Functions

Pooja Goel  |   Nov 11, 2019  |  Views: 22

SQL- Date Functions

Pooja Goel  |   Nov 11, 2019  |  Views: 16

SQL-TRIGGER

Pooja Goel  |   Nov 11, 2019  |  Views: 12

SQL-CTE

Pooja Goel  |   Nov 10, 2019  |  Views: 12

SQL-Stored Procedures

Pooja Goel  |   Nov 10, 2019  |  Views: 13

SQL-Temporary Tables

Pooja Goel  |   Nov 9, 2019  |  Views: 9

SQL-Merge

Pooja Goel  |   Nov 9, 2019  |  Views: 15

SQL-Subquery

Pooja Goel  |   Nov 9, 2019  |  Views: 57

SQL-EXISTS Operator

Pooja Goel  |   Nov 9, 2019  |  Views: 21

SQL- AND & OR Operator

Pooja Goel  |   Nov 8, 2019  |  Views: 9

SQl-Group by/Order by Clause

Pooja Goel  |   Nov 8, 2019  |  Views: 8

SQL-Where/Having Clauses

Pooja Goel  |   Nov 7, 2019  |  Views: 9

SQL-TOP Clause

Pooja Goel  |   Nov 7, 2019  |  Views: 16

SQL-CASE STATEMENT

Pooja Goel  |   Nov 7, 2019  |  Views: 12

SQL-UNION/UNION ALL

Pooja Goel  |   Nov 7, 2019  |  Views: 9

SQL-COMMENTS

Pooja Goel  |   Nov 6, 2019  |  Views: 45

SQL- ALIAS SYNTAX

Pooja Goel  |   Nov 6, 2019  |  Views: 6

SQL-IS NULL/ NOT NULL

Pooja Goel  |   Nov 6, 2019  |  Views: 13

SQL-IN & BETWEEN

Pooja Goel  |   Nov 6, 2019  |  Views: 10

SQL- DDL, DML, TCL and DCL

Pooja Goel  |   Nov 6, 2019  |  Views: 24

SQL-Aggregate Function

Pooja Goel  |   Nov 5, 2019  |  Views: 9

SQL-Like

Pooja Goel  |   Nov 5, 2019  |  Views: 15

SQL-Constraints

Pooja Goel  |   Nov 5, 2019  |  Views: 20

SQL-Views

Pooja Goel  |   Nov 5, 2019  |  Views: 19

SQL-Indexes

Pooja Goel  |   Nov 5, 2019  |  Views: 10

SQL-JOINS

Pooja Goel  |   Nov 4, 2019  |  Views: 30

SQL-SELECT Statement

Pooja Goel  |   Nov 4, 2019  |  Views: 22

SQL- DELETE Statement

Pooja Goel  |   Nov 4, 2019  |  Views: 25

SQL- UPDATE Statement

Pooja Goel  |   Nov 4, 2019  |  Views: 22

SQL- INSERT Statement

Pooja Goel  |   Nov 4, 2019  |  Views: 33

SQL- DROP / TRUNCATE TABLE

Pooja Goel  |   Nov 4, 2019  |  Views: 36

SQL-CREATE TABLE

Pooja Goel  |   Nov 4, 2019  |  Views: 31

SQL-DROP DATABASE

Pooja Goel  |   Nov 4, 2019  |  Views: 39

SQL-CREATE DATABASE

Pooja Goel  |   Nov 4, 2019  |  Views: 53

SQL-Introduction

Pooja Goel  |   Nov 4, 2019  |  Views: 297

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale