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

When writing a sql insert database

to_date('20140509131034','yyyyMMddHHmmss')

The reason is that the year in java and the year in oracle are not expressed in the same form

Oracle uses MI for minutes, not mm in Java.

modified to

to_date('20140509131034','yyyyMMddHHMISS')

ORA-01849: Hour value must be between 1 and 12

Because the 24-hour format is displayed as HH24

modified to

to_date('20140509131034','yyyyMMddHH24MISS')

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.