oracle时间格式问题 oracle时间格式问题向oracle表中插入时间 格式总错 (ORA-01861: literal does not match format string)什么样的格式可以啊vb.net的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用OracleParameter传...不要拼SQL字符串... 用OracleParameter传最好如果拼接的话.要用to_date()把日期转一下如:select to_date('2008-10-11','YYYY-MM-DD') from dual OracleParameter是什么怎么用啊?有例子吗? OracleParameter是什么怎么用啊?有例子吗? 自己查一下msdn就是用参数化的方式给你的语句传参如:string sql = "select * from table1 where id =:Iid"; OracleParameter pa = new OracleParameter(); pa.ParameterName = "Iid"; pa.Value = 1; pa.OracleType = OracleType.Int32;OracleCommand cmd = new OracleCommand(sql,conn);cmd.Parameters.Add(pa);........简单写了一下.你可以去msdn上查查.都有例子的. DateTime[] dateTimeList = new DateTime[3]; dateTimeList[0] = DateTime.Parse("2008-08-05 06:49:26"); dateTimeList[1] = DateTime.Parse("2008-08-05 06:49:27"); dateTimeList[2] = DateTime.Parse("2008-08-05 06:49:28"); string connection = System.Configuration.ConfigurationSettings.AppSettings["oracleconn"].ToString(); OracleConnection oconn = new OracleConnection(); oconn.ConnectionString = connection; oconn.Open(); OracleCommand cmd = new OracleCommand(); OracleTransaction txn = oconn.BeginTransaction(IsolationLevel.ReadCommitted); try { cmd.CommandText = "insert into test(DATETIMES,flag) values (:DATETIMES,'1')"; cmd.Connection = oconn; cmd.ArrayBindCount = 3; OracleParameter prm = new OracleParameter("DATETIMES", OracleDbType.TimeStamp); prm.Direction = ParameterDirection.Input; prm.Value = dateTimeList; cmd.Parameters.Add(prm); cmd.ExecuteNonQuery(); txn.Commit(); } catch (OracleException ex) { txn.Commit(); } oconn.Close(); oconn.Dispose(); 建议使用 oralceParameter 类来实现参数的传递。如果单独写 sql 语句,oracle 的日期表示如下:-- 日期select date'2008-10-15' from dual;-- 日期加时间select timestamp'2008-10-15 15:16:02' from dual;-- to_date 函数select to_date('2008-10-15 15:16:17', 'yyyy-mm-dd hh24:mi:ss') from dual; 如果我想插入该什么实现啊?是这样吗?INSERT INTO MEMBER (MEMBER_ID, MEMBER_NAME, AUTHORITY, UPDATE_DATE, PASSWORD) VALUES('0006','s','0','to_date(2008/10/15 15:32:03,YYYY-MM-DD hh24:mi:ss),'s') 如果我想插入该什么实现啊?是这样吗?INSERT INTO MEMBER (MEMBER_ID, MEMBER_NAME, AUTHORITY, UPDATE_DATE, PASSWORD) VALUES('0006','s','0','to_date(2008/10/15 15:32:03,YYYY-MM-DD hh24:mi:ss),'s') 请教,两个asp.net项目合并在一起。 事务添加返回值的问题。 求一判断远程图片是否是存在的函数~ 求人写一个SQL语句 提示框和跳转的问题 有没有显示歌名、歌名列表的FLASH MP3播放器? 求一 sql 语句!请各位帮帮忙. 将sql的数据显示在gridview中,更改了gridview中的数据,为什么sql中的数据不能更改? 求助实现DetailsView 部分编辑 asp与asp.net cookie 共用问题 IIS VS2005 为什么效果不一样 一个ajax无刷新的例子或者原理
如:
select to_date('2008-10-11','YYYY-MM-DD') from dual
怎么用啊?有例子吗?
怎么用啊?有例子吗?
就是用参数化的方式给你的语句传参如:
string sql = "select * from table1 where id =:Iid";
OracleParameter pa = new OracleParameter();
pa.ParameterName = "Iid";
pa.Value = 1;
pa.OracleType = OracleType.Int32;
OracleCommand cmd = new OracleCommand(sql,conn);
cmd.Parameters.Add(pa);.....
...简单写了一下.你可以去msdn上查查.都有例子的.
DateTime[] dateTimeList = new DateTime[3];
dateTimeList[0] = DateTime.Parse("2008-08-05 06:49:26");
dateTimeList[1] = DateTime.Parse("2008-08-05 06:49:27");
dateTimeList[2] = DateTime.Parse("2008-08-05 06:49:28");
string connection = System.Configuration.ConfigurationSettings.AppSettings["oracleconn"].ToString();
OracleConnection oconn = new OracleConnection();
oconn.ConnectionString = connection;
oconn.Open();
OracleCommand cmd = new OracleCommand();
OracleTransaction txn = oconn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{ cmd.CommandText = "insert into test(DATETIMES,flag) values (:DATETIMES,'1')";
cmd.Connection = oconn;
cmd.ArrayBindCount = 3;
OracleParameter prm = new OracleParameter("DATETIMES", OracleDbType.TimeStamp);
prm.Direction = ParameterDirection.Input;
prm.Value = dateTimeList;
cmd.Parameters.Add(prm);
cmd.ExecuteNonQuery();
txn.Commit();
}
catch (OracleException ex)
{
txn.Commit();
}
oconn.Close();
oconn.Dispose();
-- 日期
select date'2008-10-15' from dual;
-- 日期加时间
select timestamp'2008-10-15 15:16:02' from dual;
-- to_date 函数
select to_date('2008-10-15 15:16:17', 'yyyy-mm-dd hh24:mi:ss') from dual;
INSERT INTO MEMBER (MEMBER_ID, MEMBER_NAME, AUTHORITY, UPDATE_DATE, PASSWORD) VALUES('0006','s','0','to_date(2008/10/15 15:32:03,YYYY-MM-DD hh24:mi:ss),'s')
INSERT INTO MEMBER (MEMBER_ID, MEMBER_NAME, AUTHORITY, UPDATE_DATE, PASSWORD) VALUES('0006','s','0','to_date(2008/10/15 15:32:03,YYYY-MM-DD hh24:mi:ss),'s')