SQL Servers2008中,如何将表中数据星期从英文转化为中文,并用一条语句来完成.TimeKey FullDateAlternateKey\x05DayNumberOfWeek\x05EnglishDayNameOfWeek 1\x052001-07-01 0:00:00\x051\x05\x05Sunday2\x052001-07-02 0:00:00\x052\x05\x05M
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/25 07:08:06
![SQL Servers2008中,如何将表中数据星期从英文转化为中文,并用一条语句来完成.TimeKey FullDateAlternateKey\x05DayNumberOfWeek\x05EnglishDayNameOfWeek 1\x052001-07-01 0:00:00\x051\x05\x05Sunday2\x052001-07-02 0:00:00\x052\x05\x05M](/uploads/image/z/2503460-20-0.jpg?t=SQL+Servers2008%E4%B8%AD%2C%E5%A6%82%E4%BD%95%E5%B0%86%E8%A1%A8%E4%B8%AD%E6%95%B0%E6%8D%AE%E6%98%9F%E6%9C%9F%E4%BB%8E%E8%8B%B1%E6%96%87%E8%BD%AC%E5%8C%96%E4%B8%BA%E4%B8%AD%E6%96%87%2C%E5%B9%B6%E7%94%A8%E4%B8%80%E6%9D%A1%E8%AF%AD%E5%8F%A5%E6%9D%A5%E5%AE%8C%E6%88%90.TimeKey+FullDateAlternateKey%5Cx05DayNumberOfWeek%5Cx05EnglishDayNameOfWeek+1%5Cx052001-07-01+0%3A00%3A00%5Cx051%5Cx05%5Cx05Sunday2%5Cx052001-07-02+0%3A00%3A00%5Cx052%5Cx05%5Cx05M)
SQL Servers2008中,如何将表中数据星期从英文转化为中文,并用一条语句来完成.TimeKey FullDateAlternateKey\x05DayNumberOfWeek\x05EnglishDayNameOfWeek 1\x052001-07-01 0:00:00\x051\x05\x05Sunday2\x052001-07-02 0:00:00\x052\x05\x05M
SQL Servers2008中,如何将表中数据星期从英文转化为中文,并用一条语句来完成.
TimeKey FullDateAlternateKey\x05DayNumberOfWeek\x05EnglishDayNameOfWeek
1\x052001-07-01 0:00:00\x051\x05\x05Sunday
2\x052001-07-02 0:00:00\x052\x05\x05Monday
3\x052001-07-03 0:00:00\x053\x05\x05Tuesday
4\x052001-07-04 0:00:00\x054\x05\x05Wednesday
5\x052001-07-05 0:00:00\x055\x05\x05Thursday
6\x052001-07-06 0:00:00\x056\x05\x05Friday
7\x052001-07-07 0:00:00\x057\x05\x05Saturday
8\x052001-07-08 0:00:00\x051\x05\x05Sunday
9\x052001-07-09 0:00:00\x052\x05\x05Monday
TimeKey FullDateAlternateKey DayNumberOfWeek\x05EnglishDayNameOfWeek
1\x052001-07-01 0:00:00\x05 1\x05\x05Sunday
2\x052001-07-02 0:00:00\x05 2\x05\x05Monday
3\x052001-07-03 0:00:00\x05 3\x05\x05Tuesday
4\x052001-07-04 0:00:00\x05 4\x05\x05Wednesday
5\x052001-07-05 0:00:00 \x055\x05\x05Thursday
6\x052001-07-06 0:00:00 \x056\x05\x05Friday
7\x052001-07-07 0:00:00 \x05 7\x05\x05Saturday
8\x052001-07-08 0:00:00 \x051\x05\x05Sunday
9\x052001-07-09 0:00:00 \x052\x05\x05Monday
SQL Servers2008中,如何将表中数据星期从英文转化为中文,并用一条语句来完成.TimeKey FullDateAlternateKey\x05DayNumberOfWeek\x05EnglishDayNameOfWeek 1\x052001-07-01 0:00:00\x051\x05\x05Sunday2\x052001-07-02 0:00:00\x052\x05\x05M
1.select datename(weekday,DayNumberOfWeekEnglishDayNameOfWeek
)
2.select datename(weekday,FullDateAlternateKey)