Shulou(Shulou.com)06/01 Report--

Sometimes the sysdate of oracle is compared with the time field in the database, so to_char and to_date are needed.

Select h.resourceid, to_char (to_date (h.Closekeeping time.MMMurdd hh34:mi:ss'), 'yyyy-MM-dd'), to_char (sysdate,'yyyy-MM-dd') from IMS_NW.alert_info_history h

Where to_char (to_date (h.Closetimes timejour Mmurdd hh34:mi:ss'), 'yyyy-MM-dd') = to_char (sysdate,'yyyy-MM-dd')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.