| | | 10.8.15.select DATEPART(week, '2002-09-30 11:35:00') |
|
|
3> select DATEPART(week, '2002-09-30 11:35:00')
4> GO
-----------
40
(1 rows affected)
|
|
| 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 |
|