Home > Net >  In c # using the INSERT to INSERT the DATE type error in the ORACLE database
In c # using the INSERT to INSERT the DATE type error in the ORACLE database

Time:10-03

Connect the ORACLE database
Use strSql="insert into TEST (SJ) values ('" + DateTime. Now + "')

SJ is the DATE format
The use of an "ORA - 01861, words and the format string does not match"
What is your solution?

CodePudding user response:

To_date (' # ', '- dd yyyy - mm hh24: mi: ss') under the date will be shifted

CodePudding user response:

The inside of the oracle date need transformation can be saved

CodePudding user response:

DateTime. Now. The Date
The database is the date, not a datetime
  •  Tags:  
  • C#
  • Related