各个数据库中date的比较

oracle : select * from INTERNAL_LOAN WHERE to_char(REPAYMENTDATE, 'YYYY-MM-DD HH24:MI:SS') > '2015-04-18 00:00:00';

mysql :select * from ysm_advertisement where (to_days(now()) <= (to_days(createDate)+7)) 

sql server:

queryString = "where CONVERT(char(20),GetdataTime,23) Between '" + begintime + "' And '" + endtime + "'";

其中 CONVERT(char(20),GetdataTime,23)将保留日期部分，例如2007－06－05