Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ttt;Data Source=tiger"
conn.Open
Set rs = New ADODB.Recordset
rs.Open "select getdate() as fldTime", conn
MsgBox rs.Fields("fldtime")
MsgBox Format(rs.Fields("fldtime"), "hh:mm")
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ttt;Data Source=tiger"
conn.Open
Set rs = New ADODB.Recordset
rs.Open "select getdate() as fldTime", conn
MsgBox rs.Fields("fldtime")
MsgBox Format(rs.Fields("fldtime"), "hh:mm")
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货