string myDate = "10/9/2012 2:55:25 PM"; string sql = "SELET * FROM SomeTable WHERE SomeDateField=" + "to_date('" + myDate + "','" + "MM/DD/YYYY HH:MI:SS " + myDate.Substring(myDate.Length - 2) + "');";
Next: C# Querying From An Oracle Database
string myDate = "10/9/2012 2:55:25 PM"; string sql = "SELET * FROM SomeTable WHERE SomeDateField=" + "to_date('" + myDate + "','" + "MM/DD/YYYY HH:MI:SS " + myDate.Substring(myDate.Length - 2) + "');";
At Casino Niagara Noon – 4:00am daily ... or visit the Momentum Desk or VIP Services Desk at.
ReplyDeleteOracle dates have a different format than SQL Server dates. 1depositcasinouk So to select a date for the Oracle database you have to have the date in the following format.
ReplyDelete