当前位置：网站首页>How does sqlserver insert or update the number of weeks of the day instead of text

How does sqlserver insert or update the number of weeks of the day instead of text

2022-04-23 12:16:00 【CSDN Q & A】

SQLserver How to insert or update the number of weeks of the day ,bit Not the text .
Please grant me your advice



Take the answer ：

Your problem can't be realized SQLServer bit type Can only store 0 1 null Unable to store the number of weeks . If you want to get the day of the week, you can use the following statement

-- Set the language of the database to Chinese
SET LANGUAGE N'Simplified Chinese'
-- Get the day of the week
SELECT DATENAME(weekday,GETDATE())

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204162106055566.html

边栏推荐

猜你喜欢

随机推荐