Sql server® 2012 t-sql fundamentals

The 

ISDATE

 Function

The ISDATE function accepts a character string as input and returns 1 if it is convertible to a date and 

time data type and 0 if it isn’t.

Syntax

ISDATE(string)

For example, the following code returns 1.

SELECT ISDATE('20090212');

And the following code returns 0.

SELECT ISDATE('20090230');

www.it-ebooks.info

---

 

CHAPTER 2

 

Single-Table Queries

 

 87

The 

FROMPARTS

 Functions

The FROMPARTS functions were introduced in SQL Server 2012. They accept integer inputs represent-

ing parts of a date and time value and construct a value of the requested type from those parts. 

Syntax

DATEFROMPARTS (year, month, day)

DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision)

DATETIMEFROMPARTS (year, month, day, hour, minute, seconds, milliseconds)

DATETIMEOFFSETFROMPARTS (year, month, day, hour, minute, seconds, fractions, hour_offset, min-

ute_offset, precision)

SMALLDATETIMEFROMPARTS (year, month, day, hour, minute)

TIMEFROMPARTS (hour, minute, seconds, fractions, precision)

These functions make it easier for applications to construct date and time values from the differ-

ent components, and they also simply migrate from other environments that already support similar 

functions. The following code demonstrates the use of these functions.

SELECT 

  DATEFROMPARTS(2012, 02, 12), 

  DATETIME2FROMPARTS(2012, 02, 12, 13, 30, 5, 1, 7), 

  DATETIMEFROMPARTS(2012, 02, 12, 13, 30, 5, 997), 

  DATETIMEOFFSETFROMPARTS(2012, 02, 12, 13, 30, 5, 1, -8, 0, 7), 

  SMALLDATETIMEFROMPARTS(2012, 02, 12, 13, 30), 

  TIMEFROMPARTS(13, 30, 5, 1, 7);