DATEPART Intellisense Suggestions incomplete

afthornbury

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

Tianjiao_Li

Hi @afthornbury

Thanks for bringing this to our attention!

We have got this one logged as an enhancement internally but the team hasn't been able to priorities it. Would you be able to post this suggestion on user voice https://redgate.uservoice.com/forums/94413-sql-prompt 

Thanks!