| 10.8.DATEPART |
| 10.8.1. | DATEPART returns part of a date as an integer value. |
| 10.8.2. | Values for the datepart parameter. |
| 10.8.3. | WHERE DATEPART(WEEKDAY, pubdate) = 3 |
| 10.8.4. | where DATEPART(DAY, pubdate) BETWEEN 8 AND 14 |
| 10.8.5. | where DATEDIFF(WEEK, pubdate, GETDATE()) <= 48 |
| 10.8.6. | DATEPART Function returns the integer value of the datepart specified: DATEPART(datepart,date) |
| 10.8.7. | select DATEPART(day, '2002-09-30 11:35:00') |
| 10.8.8. | select DATEPART(month, '2002-09-30 11:35:00') |
| 10.8.9. | select DATEPART(year, '2002-09-30 11:35:00') |
|
| 10.8.10. | select DATEPART(hour, '2002-09-30 11:35:00') |
| 10.8.11. | select DATEPART(minute, '2002-09-30 11:35:00') |
| 10.8.12. | select DATEPART(second, '2002-09-30 11:35:00') |
| 10.8.13. | select DATEPART(quarter, '2002-09-30 11:35:00') |
| 10.8.14. | select DATEPART(dayofyear, '2002-09-30 11:35:00') |
| 10.8.15. | select DATEPART(week, '2002-09-30 11:35:00') |
| 10.8.16. | select DATEPART(weekday, '2002-09-30 11:35:00') |
| 10.8.17. | select DATEPART(m,'2002-09-30') |
| 10.8.18. | SELECT DATEPART(dd, '7/5/99') |
| 10.8.19. | SELECT DATEPART(dd, '7/5/00') |
|
| 10.8.20. | IF DATEDIFF(dd, '7/5/99','7/5/00') = 0 |
| 10.8.21. | (DATEPART(mm, @date1) = DATEPART(mm, @date2)) |
| 10.8.22. | (DATEPART(dd, @date1) = DATEPART(dd, @date2)) |
| 10.8.23. | (DATEPART(yy, @date1) = DATEPART(yy, @date2) |
| 10.8.24. | Identifying Weekday |
| 10.8.25. | Grouping by the Week by using datepart function |