Home > database >  Small white consulting SQL how to pick a weekend date
Small white consulting SQL how to pick a weekend date

Time:11-12


Using VFP processing data, Createdate listed 20200 x0x date, need to put forward the date of the weekend, what the statement? Trouble great god under the guidance of the whole sentence, thank you

CodePudding user response:

The SET DATEFIRST 1
Select * from table name
Where datepart (weekday, createdate) in (' 6 ', '7')
  • Related