問題描述
在 SQL Server 中，您可以使用 DATENAME 函數(shù)以字符串形式獲取星期幾
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 函數(shù)以整數(shù)形式獲取星期幾
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，我想將它轉(zhuǎn)換為 3 的整數(shù)表示.當然，我可以毫不費力地寫出轉(zhuǎn)換，但我更愿意使用內(nèi)置的- 在功能.有這樣的功能嗎?
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?
推薦答案
與其編寫函數(shù)，不如創(chuàng)建一個包含說明和數(shù)值的星期幾表.然后您可以簡單地加入表格以獲取數(shù)字.
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.
如果您以多種方式存儲天數(shù)(可能在基于字符的系統(tǒng)中)，您可以將所有變體放入表中，因此 TUE、Tues.、Tuesday 都將映射到相同的整數(shù).
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.
這篇關于將一天的名稱轉(zhuǎn)換為其整數(shù)表示的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！