問題描述
在 SQL Server 中，您可以使用 DATENAME 函數以字符串形式獲取星期幾
In SQL server you can use the DATENAME function to get the day of week as a string
declare @date datetime
set @date = '12/16/08'
select datename(dw, @date)
返回星期二"
并且您可以使用 DATEPART 函數以整數形式獲取星期幾
and you can use the DATEPART function to get the day of week as an integer
declare @date datetime
set @date = '12/16/08'
select datepart(dw, @date)
返回 3
但是假設我有一個包含字符串Tuesday"的 varchar，我想將它轉換為 3 的整數表示.當然，我可以毫不費力地寫出轉換，但我更愿意使用內置的- 在功能.有這樣的功能嗎?
But say I have a varchar that contains the string "Tuesday" and I want to convert it to its integer representation of 3. Sure, I could write out the conversion without much hassle, but I'd much rather use a built-in function. Does such a function exist?
推薦答案
與其編寫函數，不如創(chuàng)建一個包含說明和數值的星期幾表.然后您可以簡單地加入表格以獲取數字.
Rather than write a function, you should create a days of the week table with the description and the numeric value. THen you can simply join to the table to get the numeric.
如果您以多種方式存儲天數(可能在基于字符的系統(tǒng)中)，您可以將所有變體放入表中，因此 TUE、Tues.、Tuesday 都將映射到相同的整數.
And if you have days stored multiple ways (likely in a characterbased system), you can put all the variants into the table, so TUE, Tues., Tuesday would all map to the same integer.
這篇關于將一天的名稱轉換為其整數表示的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！