Return-Path: Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: (qmail 86547 invoked from network); 13 Oct 2010 00:34:54 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 Oct 2010 00:34:54 -0000 Received: (qmail 75690 invoked by uid 500); 13 Oct 2010 00:34:51 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 75658 invoked by uid 500); 13 Oct 2010 00:34:51 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 75646 invoked by uid 99); 13 Oct 2010 00:34:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Oct 2010 00:34:51 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of goksron@gmail.com designates 209.85.216.48 as permitted sender) Received: from [209.85.216.48] (HELO mail-qw0-f48.google.com) (209.85.216.48) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Oct 2010 00:34:42 +0000 Received: by qwf7 with SMTP id 7so766034qwf.35 for ; Tue, 12 Oct 2010 17:34:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding:x-antivirus :x-antivirus-status; bh=jUyXAge48svf+13RoYZKyfX/4vXFZ320THH86PHGFRI=; b=AB0P7w6jL9iL80U9ruCMi0xWsuvkmnmMGiuzk2Lwyx/vt68wm9+yWyV8HmCQ/9sCfz w+wNvt/QPwqatxNLH4e6YFLJbDfyaO7OuRGEQbFFW6t5SiC52SUotesN2GNatWG+rc+P Ag7SDNtH8h8cAn/LDeOFK5klwBzVqwMoqJZH8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding:x-antivirus :x-antivirus-status; b=MYAYxp6FJrdbYk6L3k5amef5RY+IHnbV88uMjPjmlVpBjQxcienZ3vqNUWZ9yr07D4 BKrxv34/tPIg6S6bo4Dky5ZkT0viDOV8J5IUtKu5oP5Hwg/jfNhcexl4nHgs/4jaCljm qWGjAjerCm9ev4wdRUhfPOe47HxhFFhTWLW90= Received: by 10.224.181.139 with SMTP id by11mr6324002qab.172.1286930061335; Tue, 12 Oct 2010 17:34:21 -0700 (PDT) Received: from [127.0.0.1] (64-79-127-126.static.wiline.com [64.79.127.126]) by mx.google.com with ESMTPS id q3sm2735785vcr.27.2010.10.12.17.34.19 (version=SSLv3 cipher=RC4-MD5); Tue, 12 Oct 2010 17:34:20 -0700 (PDT) Message-ID: <4CB4FE8B.8020100@gmail.com> Date: Tue, 12 Oct 2010 17:34:19 -0700 From: Lance Norskog User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.13) Gecko/20100914 SeaMonkey/2.0.8 MIME-Version: 1.0 To: solr-user@lucene.apache.org Subject: Re: Yet another date format problem References: <97BC9B6A-3C2F-4449-BBDF-15F43C2F8D0B@roxxor.co.uk> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 101012-1, 10/12/2010), Outbound message X-Antivirus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org > 2007-06-19 09:08:48 Solr's input format is '2007-06-19T09:08:48Z'. More to the point: you are creating a string and passing that in. The date type will accept this, but the DIH has code to accept Java JDBC datetime values directly. So, in your select you want to somehow cast your field data into your db's actual Date type. Erick Erickson wrote: > > 2007-06-19 09:08:48 >