摘要: Bug 1 p6spy查询怪现象
SELECT DISTINCT convert(char(10),date_ssqqr,111),convert(char(10),date_ssqzr,111) FROM mid_nsr_sbxm WHERE id_nsr='3204'
这句sql在p6spy中执行后返回的log是 "= 2006/01/01",而
SELECT DISTINCT convert(char(10),date_ssqqr,111),date_ssqzr FROM mid_nsr_sbxm WHERE id_nsr='3204'
执行后返回 "= 2006/01/01, date_ssqzr = 2006-03-31 00:00:00.0",而
SELECT DISTINCT date_ssqqr,date_ssqzr FROM mid_nsr_sbxm WHERE id_nsr='3204'
返回 "date_ssqqr = 2006-03-01 00:00:
阅读全文