Comparing database dates: SELECT FROM WHERE Date(today) < MYDATECOL ?

From: Thomas Stein (thosteno5pam_at_email.com)
Date: 02/07/05

  • Next message: Lee Fesperman: "Re: Is perl better? :(((" 
    Date: Mon, 7 Feb 2005 20:40:00 +0100

    I want to get in a java prgm all those database records whose MYDATE column contains a
    date greater equal a given other date (say: today). How do I specify this
    in a SQL query from Java?

    Assume the comparison date in java is in a java.util.Date field. Do I have to convert it
    into a variable of type java.sql.Date?

    The resulting code should look similar to:

    java.util.Date somejavadate = new java.util.Date();
    java.sql.Date somesqldate = new java.sql.Date(somejavadate);

    rs = stmt.executeQuery("SELECT ... FROM ... WHERE " + somesqldate + "<= MYDATECOL");

    MYDATECOL is defined with a type "datetime".

    However this does not work.
    How does the exact query look like?

    Is the date query database product specific?

    Thomas

  • Next message: Lee Fesperman: "Re: Is perl better? :((("

    Relevant Pages