1) case when date1>date2 then 1 else 0 end 2) SELECT ABS(DATE '2009-10-1' - DATE '2009-10-2')*60*24 FROM dual
你到底是想在VC中实现还是ORACLE中用SQL来实现?
if(date1>date2 ) int flag=1; 运行:error C2593: 'operator <' is ambiguous
cast(date2 as timestamp)-cast(date1 as timestamp) 可以计算时间差
1) case when date1>date2 then 1 else 0 end 2) SELECT ABS(DATE '2009-10-1' - DATE '2009-10-2')*60*24 FROM dual
select sign(date1-date2)flag,(date1-date2)*24*60 time from...date1和date2为两个要比较的date型数据。若相减值为负,sign返回-1,正,返回1,0,返回0. date1-date2的值的单位为天,转换成分钟只需*1440即可,根据需要添加round函数对结果进行四舍五入
2) SELECT ABS(DATE '2009-10-1' - DATE '2009-10-2')*60*24 FROM dual
int flag=1;
运行:error C2593: 'operator <' is ambiguous
2) SELECT ABS(DATE '2009-10-1' - DATE '2009-10-2')*60*24 FROM dual
date1-date2的值的单位为天,转换成分钟只需*1440即可,根据需要添加round函数对结果进行四舍五入