oracle 與mysql 的目前時間比較

標籤：比較   dex   _id   log   img   state   style   oracle   nload   

select        p.id,p.order_Num,p.image_url,p.url,p.image_topic,        p.is_download,        p.big_image_url,        p.begin_time,p.end_time        from PAGE_INDEX_IMG p where p.is_delete=‘N‘                         and p.image_Type =7                         and p.url =app                  and now() >=p.begin_time                   and now()<p.end_time        order by p.order_Num

 select eht.TAB_ID,eht.TAB_NAME from EC_HOMEPAGE_TAB  eht        WHERE eht.IS_DELETE = ‘N‘            AND eht.STATE_NUM <> 1            AND TO_DATE(eht.ONLINE_TIME,‘YYYY/MM/DD hh24:mi:ss‘) <= SYSDATE           AND TO_DATE(eht.OFFLINE_TIME,‘YYYY/MM/DD hh24:mi:ss‘) >= SYSDATE                ORDER BY  eht.ORDER_NUM;

 

oracle 與mysql 的目前時間比較