ʾ£
<% if datediff("d",rsdb("szz1"),now())>0 then
yss="#999999"
else
yss="#0033CC"
end if%>
幦
<%=datediff("d","2010-03-01 00:00:00",now())%>
DateDiff
:֮ʱ
:DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear>)
interval: ѡַʽʾڼ date1 date2 ֮ʱйֵġá֡
date1, date2: ѡڱʽڼڡ
firstdayofweek: ѡָеһijûָĬΪաйֵġá֡
firstweekofyear: ѡָһеһܵijûָĬΪ 1 1 ڵڡйֵġá֡
interval ֵ
yyyy () q () m () y (һ) d () w (һܵ) ww () h (Сʱ) n () s ()
firstdayofweek ֵ
(·ֱΪ ֵ )
vbUseSystem 0 ʹ֧ (NLS) API á
vbSunday 1 գĬϣ
vbMonday 2 һ
vbTuesday 3 ڶ
vbWednesday 4
vbThursday 5
vbFriday 6
vbSaturday 7
firstweekofyear ֵ
(·ֱΪ ֵ )
vbUseSystem 0 ʹ֧ (NLS) API á
vbFirstJan1 1 1 1 ڵڿʼĬϣ
vbFirstFourDays 2 ĵһܿʼ
vbFirstFullWeek 3 µһеһܿʼ
˵:DateDiff ж֮ڵָʱĿʹ DateDiff ߵ쵽һ֮
Ҫ date1 date2 ʹáһyաd interval ΪһܵwʱDateDiff ֮ date1 һ DateDiff 㵽 date2 ֮ǰһĿ˽ date2 date1 interval ǡܡww DateDiff ֮ date1 date2 ֮յĿ date2 գDateDiff date2ʹ date1 գҲ date1
date1 date2 DateDiff ظ
firstdayofweek ʹáw͡wwŵļӰ졣
date1 date2 ָ֣ȻΪڵĹ̶֡ date1 date2 (" ") вʡݣڴÿμ date1 date2 ʽʱ뵱ǰݡͿԱдڲͬݵij롣
interval ΪꡱyyyyʱȽ 12 31 պ 1 1 գȻʵֻһ죬DateDiff 1 ʾһݡ