將日期時間壓縮為單一整數,便於:
<%
' lx 精度等級:
' 0 = 分鐘 (YYYYMMDDHHMM)
' 1 = 小時 (YYYYMMDDHH)
' 2 = 天 (YYYYMMDD)
' 3 = 月 (YYYYMM)
Function GetTimeNumber(lx)
Dim y, m, d, h, n
y = Year(Date) : m = Month(Date) : d = Day(Date)
h = Hour(Time) : n = Minute(Time)
' 雙位數補零
If Len(m)=1 Then m="0"&m
If Len(d)=1 Then d="0"&d
If Len(h)=1 Then h="0"&h
If Len(n)=1 Then n="0"&n
Select Case lx
Case 0: GetTimeNumber = CLng(y & m & d & h & n) ' 202412251430
Case 1: GetTimeNumber = CLng(y & m & d & h) ' 2024122514
Case 2: GetTimeNumber = CLng(y & m & d) ' 20241225
Case 3: GetTimeNumber = CLng(y & m) ' 202412
Case Else: GetTimeNumber = CLng(y & m & d & h & n)
End Select
End Function
%>
Function GetTimeNumberEx(dt, lx)
' dt: Date 型別,預設 Now
' lx: 0=分, 1=時, 2=日, 3=月, 4=年
' 回傳 Long (最大 202412251430 < 2.14B,安全)
If IsMissing(dt) Or Not IsDate(dt) Then dt = Now()
If lx < 0 Or lx > 4 Then lx = 0
Dim y, m, d, h, n, s, result
y = Year(dt) : m = Month(dt) : d = Day(dt)
h = Hour(dt) : n = Minute(dt) : s = Second(dt)
If Len(m)=1 Then m="0"&m
If Len(d)=1 Then d="0"&d
If Len(h)=1 Then h="0"&h
If Len(n)=1 Then n="0"&n
If Len(s)=1 Then s="0"&s
Select Case lx
Case 0: result = y & m & d & h & n
Case 1: result = y & m & d & h
Case 2: result = y & m & d
Case 3: result = y & m
Case 4: result = y
End Select
' CLng 最大 2,147,483,647,年份超過 2147 會溢位
' 改回傳字串或用 CDbl
If CLng(result) > 2147483647 Then
GetTimeNumberEx = result ' 回傳字串
Else
GetTimeNumberEx = CLng(result)
End If
End Function
Dim cacheKey
cacheKey = "ArticleList_" & GetTimeNumberEx(Now(), 1) ' 按小時快取
' 同一小時內所有請求共用同一快取
Dim fileName
fileName = "export_" & GetTimeNumberEx(Now(), 0) & "_" & Session.SessionID & ".csv"
' export_202412251430_abc123.csv
sql = "SELECT * FROM Logs WHERE TimeBucket = " & GetTimeNumberEx(Now(), 1)
' TimeBucket 欄位為 INT INDEX,查詢極快
' 統計每小時訪問量
SELECT GetTimeNumberEx(VisitTime, 1) AS HourBucket, COUNT(*) AS PV
FROM Visits
GROUP BY GetTimeNumberEx(VisitTime, 1)
ORDER BY HourBucket
<%
Dim i, t, n
n = 100000
t = Timer
For i = 1 To n
GetTimeNumber(0)
Next
Response.Write "GetTimeNumber x" & n & ": " & FormatNumber(Timer-t, 4) & " 秒
"
t = Timer
For i = 1 To n
FormatDT(Now(), 9) ' 字串格式化
Next
Response.Write "FormatDT x" & n & ": " & FormatNumber(Timer-t, 4) & " 秒
"
' 典型結果: GetTimeNumber 約 0.15s, FormatDT 約 0.45s (整數運算較快)
%>