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

The reason for reporting this error is that the minute is indicated by mm when the date is converted; as follows

To_date ('2016-06-30 16-12-21-15-5-5-5-6-16-12-12-12-16-12-12-12-16-12-12-16-12-12-12-16-12-12-12-12-12-16-12-12-12-16-12-12-12-16-12-12-12-12-16-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12, 2016-06-30, 16-15, 21-15, 57, 2016-06-30, 16, 21, 21, 51, 5, 5, 5, 5, 5, 2, 2, 4, 4, 4, 4, 4, 4, 4, 4,

The oracle format is case-insensitive, so MM and mm are the same and may be displayed in months. So

Mi is used in oracle instead of MM.

To_date ('2016-06-30 16-12-21-15-5-5-5-6-16-12-12-12-16-12-12-12-16-12-12-16-12-12-12-16-12-12-12-12-12-16-12-12-12-16-12-12-12-16-12-12-12-12-16-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12, 2016-06-30, 16-15, 21-15, 57, 2016-06-30, 16, 21, 21, 51, 5, 5, 5, 5, 5, 2, 2, 4, 4, 4, 4, 4, 4, 4, 4,

Original address: http://bbs.delit.cn/thread-1110-1-1.html

Please indicate the source of the reprint:

Written by: measurement Technology http://www.delit.cn

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.