Traditional Culture Encyclopedia - The 24 Solar Terms - How to use sql language name to find out the data of Saturday before the current date, thank you!
How to use sql language name to find out the data of Saturday before the current date, thank you!
1. If the field is a date type:
Select ... from table, where the date field = dateadd (DD, (-1) * (datepart (dw, getdate ()), getdate ()).
2. If the field is a string type, you need to know the format of the string date, and then use the convert function to obtain it.
- Previous article:Xiao nian is a sun horse.
- Next article:Chronology of cadres and branches and 24 solar terms
- Related articles
- Youth League, the food of Tomb-Sweeping Day.
- What foods can light snow solar terms improve mood?
- How to solve the short circuit of throttle to ground?
- Automobile knowledge 15 questions
- What cute models are there in JK plaid skirt-JK plaid skirt cute models collection
- The ancient poems describing snow are self-created and urgently needed! ! !
- Write the idioms of the first month. The first one is this month's idiom.
- How to treat fleeting time, how to treat fleeting time or the fate of Ryutsuki ~
- Help: Name of the girl born on 2065 438+00 1 Month 2 1 Day 10: 50.
- How to eliminate the bad chemical smell (mainly furniture) in newly renovated homes?