asp中如何将日期2008-8-8 12:00:00的格式改成2008080812的格式

如何调用数据库中2008080812这种日期格式的数据
2024-12-04 18:55:52
推荐回答(3个)
回答1:

给你一个时间格式化函数,使用起来很方便,也可以进一步修改出其他的样式,函数的使用方法就不用我说了吧!!

' ============================================
' 格式化时间(显示)
' 参数:n_Flag
' 1:"yyyy-mm-dd hh:mm:ss"
' 2:"yyyy-mm-dd"
' 3:"hh:mm:ss"
' 4:"yyyy年mm月dd日"
' 5:"yyyymmdd"
' 6:"mm-dd"
' ============================================
Function Format_Time(s_Time, n_Flag)
Dim y, m, d, h, mi, s
Format_Time = ""
If IsDate(s_Time) = False Then Exit Function
y = cstr(year(s_Time))
m = cstr(month(s_Time))
If len(m) = 1 Then m = "0" & m
d = cstr(day(s_Time))
If len(d) = 1 Then d = "0" & d
h = cstr(hour(s_Time))
If len(h) = 1 Then h = "0" & h
mi = cstr(minute(s_Time))
If len(mi) = 1 Then mi = "0" & mi
s = cstr(second(s_Time))
If len(s) = 1 Then s = "0" & s
Select Case n_Flag
Case 1
' yyyy-mm-dd hh:mm:ss
Format_Time = y & "-" & m & "-" & d & " " & h & ":" & mi & ":" & s
Case 2
' yyyy-mm-dd
Format_Time = y & "-" & m & "-" & d
Case 3
' hh:mm:ss
Format_Time = h & ":" & mi & ":" & s
Case 4
' yyyy年mm月dd日
Format_Time = y & "年" & m & "月" & d & "日"
Case 5
' yyyymmdd
Format_Time = y & m & d
case 6
'mm-dd
Format_Time = m & "-" & d
case 7 'mm-dd hh:mm
Format_Time = y & "-" & m & "-" & d & " " & h & ":" & mi
End Select
End Function

回答2:

dim stime:stime="2008-8-8 12:00:00"
dim ntime:ntime = replace(replace(replace(stime,"-","")," ",""),":","")

response.write(ntime)

回答3:

你找到相应的代码就行。修改一下显示格式