Returns a character string of the requested part of the date.
The following are valid datepart parameters:
Datepart | Abbreviations |
---|---|
year | yy, yyyy |
quarter | qq, q |
month | mm, m |
dayofyear | dy, y |
day | dd, d |
week | wk, ww |
weekday | dw, w (Sunday, Monday, etc) |
hour | hh |
minute | mi, n |
second | ss, s |
millisecond | ms |
Output: January
Output: Monday