ç¸ååªææ°åç±»åææ¥æç±»åå¯ä»¥æä½ï¼å¦æ两个å符åå段åå¨çæ¯æ°åæè æ¥ææ ¼å¼çå 容ï¼å¯å¯¹ä¸¤ä¸ªå段è¿è¡è½¬æ¢ï¼ç¶ååä½ç¸åæä½ï¼
å¦ï¼ä¸¤ä¸ªå符åï¼æ°åï¼çå段
ID1 ID2
1 2
2 4
æ§è¡è¯å¥ï¼
select cast(ID2 as int)-cast(ID1 as int) from tablename;å¦ï¼ä¸¤ä¸ªå符åï¼æ¥æï¼çå段
DATE1 DATE2
2015-08-01 2015-09-01
2015-07-01 2015-10-01
æ§è¡è¯å¥ï¼
select cast(DATE2 as datetime)-cast(DATE1 as datetime) from tablename;那我有张表里有个日期 我怎么那year(getdate())减去我那个日期呢
追答year(getdate())-year(字段)
本回答被提问者采纳