日期比较的问题!
select t_form_card.*,t_item_card.* from t_form_card,t_item_card where c_member_id = 15 AND t_form_card.c_id=t_item_card.c_form_id and Convert(char(8),c_date,112) <= Convert(char(8),'2005-4-31',112) and Convert(char(8),c_date,112) >= Convert(char(8),'2005-4-1',112) order by c_date desc取不出来值
而select t_form_card.*,t_item_card.* from t_form_card,t_item_card where c_member_id = 15 AND t_form_card.c_id=t_item_card.c_form_id and Convert(char(8),c_date,112) <= Convert(char(8),'2005-4-31',112) and c_date >= Convert(char(8),'2005-4-1',112) order by c_date desc
就能取出来值,奇怪
有人说下为什么吗?