How does SQL Server query data between two dates?

loverabbit

If you want to query the data from the 29th of last month to the 28th of this month, how should you write search conditions?

恶魔右指

select * from ta where date bewteen '2016-12-29 00: 00: 00'and' 2017-01-28 23:59:59 '

德鲁伊

where date> = 29th of last month and date <= 28th of this month? ?

wgfxman

where date field> = '2016-09-29' AND date field <'2016-10-29'
The field is a date type, it is recommended to use> =\<

haigerrual

Well, I think all the upstairs are positive solutions, unless the landlord has other ideas

unkmass

select * from table where datefield> = cast (convert (char (8), dateadd (m, -1, getdate ()), 120) + '29' as datetime) and datefield <= cast (convert (char (8) , getdate (), 120) + '28' as datetime);

sojan_game

where datecolumn between '2002-10-29' and '2003-11-29'
The general meaning is the above. Maybe the data types do not match well. Let me adjust it myself.

不悔不牛

Upstairs are all positive solutions

loverabbit

The correct solution upstairs, the month is not certain, it is the current month. Sorry for not saying clearly. Just run away, huh, huh.
If there is a solution for New Year's Eve? January this year and December last year

fanfan1980

--try

select * from tbName
where colName> = dateadd (month, -1, convert (char (8), getdate (), 120) + '29')
and colName <convert (char (8), getdate (), 120) + '29'