var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select query birthday between 11/31 to 12/1 every year, how?
select query birthday between 11/31 to 12/1 every year, how?
please give more info
you will actually have to give a better description of what you want.
If you are simply just trying to select those days of the month for every year then we can simply use a date function, but first let me know if that is what you are after.
where right(convert(varchar(10), [Birhtday], 120), 5) between '11-31' and '12-01'
Note that this does NOT work if the date range spans January 1st.
that's a weird range, very short, eh? and i don't see how it could possibly span january 1
in fact, it's only two days, you could even say
where convert(char(5),birthday,1) in ('11/31','12/01')