sql转转后语句时间问题

select id,adduser,[time] from [news] where adduser=’"&username&"’ and [time]>#"&ymd1&"# and [time]<#"&ymd2&"# order by id desc

转换后修改为下面即可，把#转换为’

select id,adduser,[time] from [news] where adduser=’"&username&"’ and [time]>’"&ymd1&"’ and [time]<‘"&ymd2&"’ order by id desc