ASP如何从数据库中只提取年和月,不要日相关语句为:DimrsrSetrsrConn.Execute( Selectdistinctyear(Time)
ASP如何从数据库中只提取年和月,不要日
相关语句为:Dim rsr
Set rsr = Conn.Execute( "Select distinct year(Time) From [PayList] ")
此语句可提取格式为2007,如何才能提取2007-04 请高手指教!
[解决办法]
Set rsr = Conn.Execute( "Select distinct left(Time,7) From [PayList] ")