Company development system supports Excel to upload data to the oracle database, may Excel format problems (Excel time format, such as: normal 2016/12/25), but uploaded to the database, the time becomes like 1000-00-00 a variety of similar to the code format, how do I in the database query out this batch of unbalanced data, thank you!

CodePudding user response:

This depends on your application, it is how to pass.

CodePudding user response:

 
As with t (
Select '2016/12/25' from a dual union all 
Select '1000-00-00' from dual 
) 
Select * from t where instr (a, '-') & gt; 0 

CodePudding user response:

Data has been imported into the database?
Corresponding field in the database is of type varchar,
Normal field display format is what look like?