取出时间完全一致的,包括分/秒 select t2.* from t1,t2 where t1.dateCol=t2.dateCol; 或者取出仅仅日期一致的,但时分秒不一定一样: select t2.* from t1,t2 where trunc(t1.dateCol)=trunc(t2.dateCol);
取出时间完全一致的,包括分/秒 select t2.* from t1,t2 where t1.dateCol=t2.dateCol; 或者取出仅仅日期一致的,但时分秒不一定一样: select t2.* from t1,t2 where trunc(t1.dateCol)=trunc(t2.dateCol);
select t2.* from t1,t2 where t1.dateCol=t2.dateCol;
或者取出仅仅日期一致的,但时分秒不一定一样:
select t2.* from t1,t2 where trunc(t1.dateCol)=trunc(t2.dateCol);
select t2.* from t1,t2 where t1.dateCol=t2.dateCol;
或者取出仅仅日期一致的,但时分秒不一定一样:
select t2.* from t1,t2 where trunc(t1.dateCol)=trunc(t2.dateCol);