Bobby Brown
asked on
C#, Oracle .NET Update Datefield
Hello experts,
I am trying update one of my oracle table. one field is a datatime. How do I do that?
PPeriodStart - it is datetime
PPeriodEnd - it is datetime
OracleTransaction myOracleTransaction = Program.g_DBO.cnDB.BeginTr ansaction( ); ;
OracleCommand oraCmd = new OracleCommand();
try
{
sqlText = "UPDATE pc.pcy set " +
" PAC = " + PcyAss + ", " +
" PPeriodStart = '" + To_date(PPeriodStart, "yyyymmdd") + "', " +
" PPeriodEnd = '" + To_date(PPeriodEnd, "yyyymmdd") + "'
" WHERE CoverageID = " + CoverageID + "";
oraCmd.Connection = Program.g_DBO.cnDB;
oraCmd.CommandType = CommandType.Text;
oraCmd.CommandText = sqlText;
oraCmd.ExecuteNonQuery();
myOracleTransaction.Commit ();
return true;
I am trying update one of my oracle table. one field is a datatime. How do I do that?
PPeriodStart - it is datetime
PPeriodEnd - it is datetime
OracleTransaction myOracleTransaction = Program.g_DBO.cnDB.BeginTr
OracleCommand oraCmd = new OracleCommand();
try
{
sqlText = "UPDATE pc.pcy set " +
" PAC = " + PcyAss + ", " +
" PPeriodStart = '" + To_date(PPeriodStart, "yyyymmdd") + "', " +
" PPeriodEnd = '" + To_date(PPeriodEnd, "yyyymmdd") + "'
" WHERE CoverageID = " + CoverageID + "";
oraCmd.Connection = Program.g_DBO.cnDB;
oraCmd.CommandType = CommandType.Text;
oraCmd.CommandText = sqlText;
oraCmd.ExecuteNonQuery();
myOracleTransaction.Commit
return true;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER