ASP

Time

display server now time clock

顯示伺服主機的現在時間

display server clock time

read time
shows 
month/daye/year hour:minute:second AM or PM

讀取主機的時間
月/日/年 時:分:秒 上午或下午

ASP

Time

time different between 2 time

兩個時間差 datediff

Datediff("how_to_count",oldTime,newTime)
how to count :h,m,n,q,ww,w,yyyy,y,s,d
h=hour
m=month
q=quarter
y=which date of a year
yyyy=which year
d=which date of a month
n=minute
s=second
ww=which week of a yeay
w=which day of a week

類似 dateadd

ASP

Time

add time , Search by Date,  Search by Time, Month

DateAdd 計時差 可為+可為-

DateAdd("m",1,now) 
month plus +1 from now

    yyyy - Year
    q - Quarter
    m - Month
    y - Day of year
    d - Day
    w - Weekday
    ww - Week of year
    h - Hour
    n - Minute
    s - Second
similar to datediff

類似 datediff

ASP

Time

read the server clock: month/date/year

讀取電腦伺服器的[ 月/日/年 ]資料

server time : display month/date/year

印出電腦伺服器的[ 月/日/年 ]資料

ASP

Time

WeekDayName(WeekDay(DATE))=“Wednesday”

檢查今天是不是星期三 (一星期的第四日)

weekday()
Sunday as the first day of a week
WeekDayName(WeekDay(date))

Monday as the first dat of a week
ex: WeekDayName(WeekDay(date,vbWednesday))

注意函數weekday()
為設定一個星期的第一天是星期日
WeekDayName(WeekDay(date))

為設定一個星期的第一天是星期一
例: WeekDayName(WeekDay(date,vbWednesday))

ASP

Time

Week date time property ; function WeekDayName (intDay)

自己設定星期幾的對應回應名稱

if intDay=1 then
      WeekDayName1 = "星期日"
  elseif intDay=2 then
      WeekDayName1 = "星期一"
  elseif intDay=3 then
      WeekDayName1 = "星期二"
  elseif intDay=4 then
      WeekDayName1 = "星期三"
  elseif intDay=5 then
      WeekDayName1 = "星期四"
  elseif intDay=6 then
      WeekDayName1="星期五"
  elseif intDay=7 then
      WeekDayName1 = "星期六"
  end if

ASP

Time

<%= FormatDateTime(Now(), 0) %>

時間日期函數

FormatDateTime(Now(), n)

建立欄位時則可選擇
欄位類別 為 [datetime] 長度 8
就可能精確的比時間大小或前後

ASP

Time

Order by time

依時序排列

Order by time DESC
Order by time ASC
Order by cast(___ as datetime)