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] ")