I am new to C# and am having trouble saving dates to my oracle database due to the format. Is their an easy way to save these dates?
==========
DateTime dteToday = System.DateTime.Now;
string dteExipryDate = dteToday.AddDays(30).ToString("dd-MMM-yyyy HH:mm:ss");
string dteNotifyDate = dteToday.AddDays(27).ToString("dd-MMM-yyyy HH:mm:ss");
//Save the changed password to the Db
string SQL =
"UPDATE vec_user " +
"SET pac_password = '" + pPassword + "'," +
"passexpiredate = '" + dteExipryDate + "'," +
"passnotifydate = '" + dteNotifyDate + "' " +
"WHERE usercode = '" + pUserCode + "'";