To get integer part of a particular date, we can use DATEPART function in Sql Server.
select DATEPART(dw, '2015-05-19 12:59:30')
Output
3
This function can also be used to get Month number, year, day of the month etc. as shown below. Pass desired parameter in place of "dw" to get required details.
Parameter | Value | Description |
---|---|---|
yy | 2015 | Year |
2 | Quarter | |
mm | 5 | Month number |
dy | 139 | Day of the year |
dd | 19 | Day of the month |
wk | 21 | Week of the year |
dw | 3 | Day number of the week |
hh | 12 | Hour of the date time passed |
n | 59 | Minute of the date time passed |
ss | 30 | Second of the date time passed |
Similarly, we can also pass ms for milli seconds, mcs for micro seconds, ns for nano seconds.
To get the name part from the date, we can use DATENAME function in SQL Server.
Views: 6236 | Post Order: 68