Wrong date inserting in oracle database using .net oledb

Question

when i try to insert a record through .net using oledb it is inserting wrong data

public void param()
{
    OleDbCommand cmd2 = new OleDbCommand("INSERT INTO PARAM_INF(PRM_FRM_DT,PRM_TO_DT) values(to_date('01-Jul-2014'),to_date('01-Jul-2014'))", con) { CommandType = CommandType.Text };
    if (con.State == ConnectionState.Closed)
    {
        con.Open();
    }
    cmd2.ExecuteNonQuery();
    con.Close();
}

result select prm_frm_dt,prm_to_dt from PARAM_INF;

PRM_FRM_DT         PRM_TO_DT        
------------------ ------------------
20-JUL-01 02:00:00 20-JUL-01 02:00:00

But the same insert statement from sqldeveloper or sqlplus result is proper.

select prm_frm_dt,prm_to_dt from PARAM_INF;

PRM_FRM_DT         PRM_TO_DT        
------------------ ------------------
01-JUL-14 12:00:00 01-JUL-14 12:00:00

I'm guessing it just how the tools your using the default date format — Charlesliam
– Charlesliam, Commented Jul 4, 2014 at 5:21
Parameterized query would properly help; so you don't do text based dates which are subject to the cultures and differences between each server/platform — Allan S. Hansen
– Allan S. Hansen, Commented Jul 4, 2014 at 5:31

user1537326 · Accepted Answer · 2014-07-04 05:58:20Z

1

public void param()
{
    OleDbCommand cmd2 = new OleDbCommand("INSERT INTO PARAM_INF(PRM_FRM_DT,PRM_TO_DT) values('" + String.Format("{0:yyyy-MMM-dd}", Convert.ToDateTime("01-Jul-2014")) + "','" + String.Format("{0:yyyy-MMM-dd}", Convert.ToDateTime("01-Jul-2014")) + "')", con) { CommandType = CommandType.Text };
    if (con.State == ConnectionState.Closed)
    {
        con.Open();
    }
    cmd2.ExecuteNonQuery();
    con.Close();
}

Collectives™ on Stack Overflow

Wrong date inserting in oracle database using .net oledb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related