| datepart |
Is the part of date where the number will be added. The following table lists all
valid datepart arguments. User-defined variable equivalents are not valid.
The return data type is the data type of the date argument.
Options:
datepart parameter abbreviation includes:
- "year","yyyy","yy"
- The year part of the
date
- "quarter","qq","q"
- The quarter part of the
date
- "month","mm","m"
- The month part of the
date
- "dayofyear","dy","y"
- The day of the year from the
date
- "day","dd","d"
- The day of the month from the
date
- "week","wk","ww"
- The week of the year from the
date
- "weekday","dw"
- The day of the week from the
date
- "hour","hh"
- The hour of the day from the
date
- "minute","mi","n"
- The minute of the hour from the
date
- "second","ss","s"
- The second of the minute from the
date
- "millisecond","ms"
- The millisecond of the minute from the
date
- "microsecond","msc"
- The microsecond of the minute from the
date
- "nanosecond","ns"
- The nanosecond of the minute from the
date
|
