Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 28652 invoked from network); 4 Feb 2009 18:16:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Feb 2009 18:16:15 -0000 Received: (qmail 24019 invoked by uid 500); 4 Feb 2009 18:16:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 23987 invoked by uid 500); 4 Feb 2009 18:16:14 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 23975 invoked by uid 99); 4 Feb 2009 18:16:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Feb 2009 10:16:14 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [68.142.198.211] (HELO smtp112.sbc.mail.mud.yahoo.com) (68.142.198.211) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 04 Feb 2009 18:16:05 +0000 Received: (qmail 29650 invoked from network); 4 Feb 2009 18:15:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=m3bcBxBgkymxmpys6CdvyBtxPsHibNaxKfDTFulLXCjwBOq7zGZed2qC7ec1usjgayIO5H+EZV2TipcuuAq/dN4DfQUMLIhPoLvoCh+cTy/8vE1A0igu/63CxEP8w+686zXfmzuLltPbSg0U2X+MWWFXyAqtwrDbq3pHCBht2Ig= ; Received: from unknown (HELO ?9.72.133.48?) (kmarsdenderby@32.97.110.55 with plain) by smtp112.sbc.mail.mud.yahoo.com with SMTP; 4 Feb 2009 18:15:42 -0000 X-YMail-OSG: kaoikjsVM1nySkKPi7CvAhTkJIjN3Oi4UP.kDt_UX6bJCtXfheL2BQ3jK7YYFlHppFK8L33a1NQksk3juMZmp2pXqJM7kY3c.rTVTRj9sTnXI6UtDlIZzfuqtQPmgfqIUqaG83FRSFD7WXXpf1PNLXnqz8LxtSf9sKsqFryf0YZpgvzRDU21E7utK6g- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4989DB49.6000702@sbcglobal.net> Date: Wed, 04 Feb 2009 10:15:37 -0800 From: Kathey Marsden User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Derby/Oracle - single SQL query? References: <032D6760-74DE-4AB7-B033-11E16CCB9473@iotabits.com> In-Reply-To: <032D6760-74DE-4AB7-B033-11E16CCB9473@iotabits.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Kent Spaulding wrote: > > Is there some query format that will for both? I don't have access to Oracle, but would it work to use an explicit cast and cast(d.insertion_date as date) <= CAST('2009-02-28' AS DATE);