---
title: "‘SELECT’ Command with Date Method"  
description: "SELECT command with SQL DATE method:There is lots of date method which are widely used in SQL server database in which some are given as follows.SELEC"  
author: "Anonymous User"  
published: 2011-07-10  
updated: 2020-03-04  
canonical: https://www.mindstick.com/articles/560/select-command-with-date-method  
category: "database"  
tags: ["database"]  
reading_time: 2 minutes  

---

# ‘SELECT’ Command with Date Method

##### SELECT command with SQL DATE method:

There is lots of date method which are widely used in SQL server database in which some are given as follows.

##### SELECT command with GETDATE () function:

GETDATE () method returns current system date.

##### Syntax:

SELECT GETDATE ()

##### Example:

```
--- RETURN CURRENT SYSTEM DATESELECT GETDATE() AS TODAY_DATE
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/66f954a4-d8ec-4efa-9112-816a8eee4e97.png)

##### SELECT command with DATEADD () function:

Returns new date time value by adding an interval of date time.

##### Syntax:

SELECT DATEADD ([MONTH |YEAR |DAY], [NUMBER], DATETIME)

##### Example:

```
---- DATE ADDED AFTER AN INTERVALSELECT DATEADD(MONTH,6,GETDATE()) AS INCREMENTED_DATE
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/d275780d-2f36-413a-8f02-498b9a691836.png)

##### SELECT command with DATENAME () function:

Returns a character string that represent specified date part.

##### Syntax:

SELECT DATENAME ([DATEPART], [STARTDATE])

##### Example:

```
---- RETURNS DATENAME EITHER DAY NAME, YEAR NAME OR MONTH NAMESELECT DATENAME(DAY,GETDATE()) as DAY_STRING
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/71025fbc-cd3d-4a30-843f-e733e7329455.png)

##### SELECT command with DATEDIFF () function:

DATEDIFF () method returns date difference between two date.

##### Syntax:

SELECT DATEDIFF ([DATEPART], [STARTINGDATE], [ENDDATE])

##### Example:

```
---- RETURNS DIFFERENCE BETWEEN TWO DATE SELECT DATEDIFF(YEAR,GETDATE(),DATEADD(MONTH,6,GETDATE()))
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/608e01da-f7a8-420f-9a45-64ffc0e0544d.png)

##### SELECT command with DATEPART () function:

DATEPART () function returns the part of date such as year, day, month etc.

##### Syntax:

SELECT DATEPART ([date part], [date])

##### Example:

```
---- RETURNS DATE PART OF GIVEN DATE SELECT DATEPART(YEAR,GETDATE())
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/ac7960da-801f-4474-b6f9-36a23305ba31.png)

##### SELECT command with DATELENGHT () function:

DATELENGTH () returns the length of given date.

##### Syntax:

SELECT DATELENGHT ([given date])

##### Example:

```
--- RETURNS DATE LENGTH OF GIVEN DATESELECT DATALENGTH(GETDATE())
```

\

![‘SELECT’ Command with Date Method](https://www.mindstick.com/mindstickarticle/b08c8553-60a2-4f35-a58f-60c538c7d136/images/e0532ca8-4b48-4b3c-88ef-f3793d98745f.png)

\

---

Original Source: https://www.mindstick.com/articles/560/select-command-with-date-method

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.