DAYSINYEAR
Updated 2023-10-06 23:48:07.103000
Syntax
SELECT [westclintech].[wct].[DAYSINYEAR](
<@StartDate, datetime,>)
Description
Use the scalar function DAYSINYEAR to return the number of days in the year of the specified date.
Arguments
@StartDate
the specified date. @StartDate is an expression that returns a datetime or smalldatetime value, or a character string in date format.
Return Type
int
Remarks
If @StartDate is NULL then @StartDate = GETDATE().
Examples
SELECT wct.DAYSINYEAR('2014-09-18');
This produces the following result.
{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"365"}]}
See Also
DAYSINMONTH - Number of days in the month of the specified date