Date Formatting

Sep 30 2004 11:22 AM
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 + "'";