当我输入以下命令时,c#中有一个table== create table newstudent(注册int,名称varchar2(20),DoJoin date);
oraclecommand(1,'amit purohit', DateTime.Now());
//Error found 'nvalid month'
oraclecommand(1,'amit purohit', String.Format("{0:dd-MMM-yyyy}"));
//problme that save only date into database but i need time also. like '11-AUG-2009 11:22:32.0'
oraclecommand(1,'amit purohit', String.Format("{0:dd-MMM-yyyy hh:mm:ss}")
//also error get like string picture format in date time values
发布于 2009-08-02 07:12:34
您应该使用参数化语句,并在中添加具有相关数据的参数,并指定适当的参数类型。它的确切格式将取决于您使用的Oracle驱动程序,但它可能类似于:
command.Parameters.Add(":date", OracleDbType.DateTime).Value = ...;
发布于 2009-08-02 08:49:44
尝试如下所示(未测试的代码):
public void InsertDateTime(DateTime aoDateTime) {
using (var oracleConnection = new OracleConnection("<my connection string>"))
{
var oracleCommand = new OracleCommand(
"INSERT INTO MY_TABLE (MY_DATE_FIELD) VALUES (:pMY_DATE_VALUE)",
oracleConnection);
oracleCommand.Parameters.Add(
new OracleParameter(":pMY_DATE_VALUE", aoDateTime));
oracleConnection.Open();
oracleCommand.ExecuteNonQuery();
}
}
发布于 2009-08-02 07:13:20
你查过standard date format了吗
https://stackoverflow.com/questions/1218326
复制相似问题