oleDbDAdComm.SelectCommand.CommandText="SELECT HID, left(ReleaseTitle,18)+ '[ '+format(ReleaseDate, 'YYYY-MM-DD') +']' as strTitle FROM HouseSituation Order by ReleaseDate desc";
hid id号 ReleaseDate 日期--字段 HouseSituation 表名字 strTitle
oleDbDAdComm.SelectCommand.CommandText="SELECT HID, left(ReleaseTitle,18)+ '[ '+format(ReleaseDate, 'YYYY-MM-DD') +']' as strTitle FROM HouseSituation Order by ReleaseDate desc";
hid id号 ReleaseDate 日期--字段 HouseSituation 表名字 strTitle