摘要:
数学丢废了好久了今天用sql碰到计算某个日期的前后n天日期但为前n天挠了好久想了好久才写了个整数取反函数Function unabs(num) unabs=0-numEnd Functionsql:select * from Tables where rq>=convert(char(10),dateadd(day,0-20,@ktybrq),20) and rq<@ktybrqselect * from Tables where rq>=@ktybrq and rq<=convert(char(10),dateadd(day,20,@ktybrq),20) 阅读全文