Show all Hide all
There is no replacement function. Use DATEPART instead, with ISO_WEEK or WEEK as the part.
Returns the week number for the specified date using a specified language week number convention.
Area of use:
Week number as determined by the function.
The date to qury the week number for.
The id of the language whose week number convention should be used to compute the week number.
Specify 1 for Swedish or anything else to use Sql Server's week number convention.