两个日期相差的天数

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<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->
select DATEDIFF ( day , getdate (), ' 2010-6-25 ' )
-- 363