How to Get the Week Number from a Date in SQL Server?
To get the week number from a date in SQL Server, you can use DATENAME Built-in Function:
SELECT DATENAME(ww, GETDATE())
How to Get the Day of the Week from a Date in SQL Server?
To get the date of the week from a date in SQL Server, you can use DATENAME Built-in Function:
SELECT DATENAME(dw, GETDATE())
To get the week number from a date in SQL Server, you can use DATENAME Built-in Function:
SELECT DATENAME(ww, GETDATE())
How to Get the Day of the Week from a Date in SQL Server?
To get the date of the week from a date in SQL Server, you can use DATENAME Built-in Function:
SELECT DATENAME(dw, GETDATE())
No comments:
Post a Comment