Chapter 8 SQL Functions
305
In this chapter, the term datetime is used to mean date or time or timestamp.
The specific data type DATETIME is indicated as DATETIME.
$ For more information on datetime data types, see "Date and time data
types" on page 277.
The following date and time functions are available:
♦ "DATE function" on page 325
♦ "DATEADD function" on page 326
♦ "DATEDIFF function" on page 326
♦ "DATEFORMAT function" on page 328
♦ "DATENAME function" on page 328
♦ "DATEPART function" on page 329
♦ "DATETIME function" on page 329
♦ "DAY function" on page 330
♦ "DAYNAME function" on page 330
♦ "DAYS function" on page 330
♦ "DOW function" on page 333
♦ "GETDATE function" on page 339
♦ "HOUR function " on page 339
♦ "HOURS function " on page 340
♦ "MINUTE function" on page 348
♦ "MINUTES function" on page 348
♦ "MONTH function" on page 350
♦ "MONTHNAME function" on page 350
♦ "MONTHS function" on page 350
♦ "NOW function" on page 353
♦ "QUARTER function" on page 358
♦ "SECOND function" on page 363
♦ "SECONDS function" on page 363
♦ "TODAY function" on page 371
♦ "WEEKS function" on page 374
♦ "YEARS function" on page 375
List of functions
To Next Page
Loading...