On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

DATEPART Intellisense Suggestions incomplete

Very minor, but the Intellisense suggestions for DATEPART() are lacking two options: TZoffset and ISO_WEEK

These are legitimate options per BOL: https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver15


  • This issue is a known bug that unfortunately going to be addressed within the current plans for the product, though we do aim to fix as many as possible. If plans for the product change in the future it may be looked at again.
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.