Sql server® 2012 t-sql fundamentals

part, dt_val)

Valid values for the part argument include year, quarter, month, dayofyear, day, week, weekday, 

hour, minute, second, millisecond, microsecond, nanosecond, TZoffset, and ISO_WEEK. The last four 

parts are available in SQL Server 2008 and SQL Server 2012. As I mentioned earlier, you can use ab-

breviations for the date and time parts, such as yy instead of year, mm instead of month, dd instead 

of day, and so on.

For example, the following code returns the month part of the input value.

SELECT DATEPART(month, '20090212');

This code returns the integer 2.

The 

YEAR

, 

MONTH

, and 

DAY

 Functions

The YEAR, MONTH, and DAY functions are abbreviations for the DATEPART function returning the 

integer representation of the year, month, and day parts of an input date and time value.

Syntax

YEAR(dt_val)

MONTH(dt_val)

DAY(dt_val)

www.it-ebooks.info

---

86  

Microsoft SQL Server 2012 T-SQL Fundamentals

For example, the following code extracts the day, month, and year parts of an input value.

SELECT 

  DAY('20090212') AS theday, 

  MONTH('20090212') AS themonth, 

  YEAR('20090212') AS theyear;

This code returns the following output.

theday      themonth    theyear 

----------- ----------- ----------- 

12          2           2009

The 

DATENAME

 Function

The DATENAME function returns a character string representing a part of a date and time value.

Syntax

DATENAME(dt_val,