論壇里又有人問起日期怎樣格式化為:2004-08-09 05:02:20這樣的格式:于是寫了一個左(右)對齊的函數(shù).這函數(shù)等價于.NET里String對象的PadLeft和PadRight函數(shù)
Function PadLeft(Value,Length,sChar) Dim strText,I strText = String(Length,sChar) strText = strText & Value LeftPad = Right(strText,Length)End Function
改一下最下面則為這樣:
Function PadRight(Value,Length,sChar) Dim strText,I strText = String(Length,sChar) strText = Value & strText LeftPad = Left(strText,Length)End Function
使用例子:日期顯示
AA = year(now) & "-" & PadLeft(month(now),2,"0") & "-" & PadLeft(Day(now),2,"0") & " " & PadLeft(Hour(now),2,"0") & ":" & PadLeft(Minute(now),2,"0") & ":" & PadLeft(Second(now),2,"0")
Public Function ForMatDate(DateAndTime, Para) '格式化日期(日期時間,格式) Dim Y, M, D, H, F, S IF Not ISNumeric(Para) Or Not ISDate(DateAndTime) Then Exit Function Y = CStr(Year(DateAndTime)) M = CStr(Month(DateAndTime)):IF Len(M) = 1 Then M = "0" & M D = CStr(Day(DateAndTime)):IF Len(D) = 1 Then D = "0" & D H = CStr(Hour(DateAndTime)):IF Len(H) = 1 Then H = "0" & H F = CStr(Minute(DateAndTime)):IF Len(F) = 1 Then F = "0" & F S = CStr(Second(DateAndTime)):IF Len(S) = 1 Then S = "0" & S Select Case Para Case "0" ForMatDate = Y & "-" & M & "-" & D & " " & H & ":" & F & ":" & S Case "1" ForMatDate = Y & "-" & M & "-" & D & " " & H & ":" & F Case "2" ForMatDate = Y & "-" & M & "-" & D Case "3" ForMatDate = Y & "/" & M & "/" & D Case "4" ForMatDate = Y & "年" & M & "月" & D & "日" Case "5" ForMatDate = M & "-" & D & " " & H & ":" & F Case "6" ForMatDate = M & "/" & D Case "7" ForMatDate = M & "月" & D & "日" Case "8" ForMatDate = Y & "年" & M & "月" Case "9" ForMatDate = Y & "-" & M Case "10" ForMatDate = Y & "/" & M Case "11" ForMatDate = right(Y,2) & "-" &M & "-" & D & " " & H & ":" & F Case "12" ForMatDate = right(Y,2) & "-" &M & "-" & D Case "13" ForMatDate = M & "-" & D Case Else ForMatDate = DateAndTime End Select End Function Response.Write ForMatDate(Now,"2")
function formatsn(getnum,getbit)dim formatsnnum,formatsnpre,formatsnjformatsnnum = getbit 主站蜘蛛池模板: 章丘市| 方正县| 宜都市| 威信县| 石渠县| 乌鲁木齐市| 项城市| 滕州市| 三门峡市| 金塔县| 平遥县| 碌曲县| 茂名市| 锡林浩特市| 绥芬河市| 乌鲁木齐县| 甘洛县| 永仁县| 承德县| 临泉县| 余干县| 卢龙县| 织金县| 会同县| 霞浦县| 连州市| 水城县| 阜宁县| 景东| 禹州市| 博客| 桦川县| 来凤县| 马关县| 喀喇| 无极县| 武汉市| 嘉峪关市| 台南县| 黄大仙区| 田阳县|