#1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    26
    Rep Power
    0

    Dates and Oracle...


    Hi,

    First a general request to any and everyone... One problem that I hv encountered repeatedly is when dealing with dates in Oracle...

    Can anyone write a decent article w.r.t handling dates with Oracle such as inserting/updating etcc.. thru an JSP???


    ok, coming to my problem...

    I am trying to compare dates between my form fields and my db field but so far keep getting a format error.. Am using an Oracle Db...

    my query reads like this:

    SQL = "SELECT DISTINCT to_char(DOCUMENT.doc_date,'dd/mm/yyyy') doc_date,DOCUMENT.document_code from Document where";

    SQL += " doc_date BETWEEN '15/11/1958' AND '15/08/1988 '";

    can anyone pl tell me whats wrong up here??

    TIA,

    sands
  2. #2
  3. #3
  4. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    26
    Rep Power
    0
    been on google since morning,,...

    but the article link u provided helped...

    thnx...

IMN logo majestic logo threadwatch logo seochat tools logo