sql server 2000 ÈÕÆÚº¯Êý£¨Áª»ú°ïÖú£©

1.DATEADDº¯Êý
  ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ¡£
Óï·¨
DATEADD ( datepart , number, date )
²ÎÊý
datepart
ÈÕÆÚ²¿·Ö
Ëõд
Year
yy, yyyy
quarter
qq, q
Month
mm, m
dayofyear
dy, y
Day
dd, d
Week
wk, ww
Hour
hh
minute
mi, n
second
ss, s
millisecond
ms
2. DATEDIFFº¯Êý
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý
²ÎÊý
 datepart
Êǹ涨ÁËÓ¦ÔÚÈÕÆÚµÄÄÄÒ»²¿·Ö¼ÆËã²î¶îµÄ²ÎÊý¡£
ͬÉÏ
 
²âÊÔÊý¾Ý£º
if object_id('mma') is not null drop table mma
go
create table mma(mydate datetime)
go
insert into mma
select '20090203' union all
select '20090205' union all
select '20090209' union all
select '20091231' union all
select '20100102' union all
select '20100112' union all
select '20100116'
 
--²éѯ·µ»Ø±¾ÔµļǼ
·½·¨Ò»
select mydate from mma where datediff(m,mydate,getdate())=0(×¢µ±Ç°ÈÕÆÚÊÇ20100116)
·½·¨¶þ
SELECT * from mma WHERE CONVERT(CHAR(6), mydate,112)=CONVERT(CHAR(6),GETDATE(),112)
·½·¨Èý
select mydate from aa where substring(convert(varchar(20),getdate(),120),0,8)=substring(convert(varchar(20),mydate,120),0,8)