Time when jdbc is inserted into the Oracle database

There is a big difference between Oracle and sqlserver when inserting date data. In sqlserver, You can enclose the date data in single quotes, But Oracle must use

There is a big difference between Oracle and sqlserver when inserting date data. In sqlserver, You can enclose the date data in single quotes, But Oracle must use

There is a big difference between Oracle and sqlserver when inserting date data. In sqlserver, you can directly enclose the Date data in single quotes, But Oracle must use the to_date ('', ''') Type of strong Conversion Function to convert the display to the Date type. Example:

Insert into employee (id, name, dates) values (4, 'wang', to_date ('01-January 1, April-2001 ', 'dd-Mon-yyyy '))

Insert into employee (id, name, dates) values (5, 'wang', to_date ('01-04-2001 ', 'dd-mm-yyyy '))

,