Tech Junkie Blog - Real World Tutorials, Happy Coding!: Oracle Date Format And Compare

Wednesday, September 4, 2013

Oracle Date Format And Compare

Oracle dates have a different format than SQL Server dates. So to select a date for the Oracle database you have to have the date in the following format. 
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
 at

4 comments:

  1. AlexxioApril 18, 2022 at 5:18 PM

    At Casino Niagara Noon – 4:00am daily ... or visit the Momentum Desk or VIP Services Desk at.

    ReplyDelete
  2. Anna123aaaJune 8, 2023 at 8:04 AM

    Oracle 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
  3. AnonymousJuly 25, 2025 at 1:08 AM

    E16FD22AFB
    kiralık hacker
    hacker arıyorum
    belek
    kadriye
    serik

    ReplyDelete
  4. AnonymousDecember 25, 2025 at 4:16 PM

    B4BB400B34
    Takipçi Satın Al
    VDS Satın Al
    Video indir

    ReplyDelete