两个日期相差的天数

import java.text.SimpleDateFormat; import java.util.Date; public class TestDate { public static void main(String[] args) { Date date = new Date(); String num = "2009-6-10"; try{ Date m_endTime = new java.text.SimpleDateFormat("yyyy-MM-dd").parse("2009-6-28"); System.out.println((date.getTime()- m_endTime.getTime())/86400000); }catch(Exception ex){ ex.printStackTrace(); } } }

oracle数据库
select floor(to_date('20080301','yyyymmdd')-sysdate) from dual;

 

SQL  2k code
select DATEDIFF(day,getdate(),'2010-6-25')
--363