时间格式化

[dhdhzzw]

怎样把数据库的时间格式化成固定样式

数据库时间 2009-6-18 8:05:12

想让它显示为 2009-06-18 08:05:12

[ttt2]

2009-06-18 08:05:12
取数各部分，然后判断是1位就加个0,好像asp没这方面的函数

[hookee]

dt = CDate("2009-6-18 8:05:12")
y  = Year(dt)
m = Month(dt)
d = Day(dt)
h = Hour(dt)
n = Minute(dt)
s = Second(dt)
m = Right("0" & m, 2)
d = Right("0" & d, 2)
h = Right("0" & h, 2)
n = Right("0" & n, 2)
s = Right("0" & s, 2)

dt = y & "-" & m & "-" & d & " " & h & ":" & n & ":" & s
Response.Write dt

[dhdhzzw]

好的谢谢