While the year zero exists, month zero and day zero don't. And while
APIs ofttimes accept those values (ie day zero is the last day of the
previous month) the ISO 8601 spec does not accept it as far as I know.
On 11/18/2010 4:26 AM, Dennis Gearon wrote:
I thought that that value was a perfectly valid one for ISO 9601 time?
http://en.wikipedia.org/wiki/Year_zero
Dennis Gearon
Signature Warning
----------------
It is always a good idea to learn from your own mistakes. It is usually a better
idea to learn from others’ mistakes, so you do not have to make them yourself.
from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036'
EARTH has a Right To Life,
otherwise we all die.
----- Original Message ----
From: gwk<g...@eyefi.nl>
To: solr-user@lucene.apache.org
Sent: Wed, November 17, 2010 2:12:16 AM
Subject: Re: DateFormatTransformer issue with value 0000-00-00T00:00:00Z
On 11/16/2010 1:41 PM, Shanmugavel SRD wrote:
Hi,
I am having a field as below in my feed.
<field name="published_from_dt">0000-00-00T00:00:00Z</field>
I have configured the field as below in data-config.xml.
<field column="published_from_dt"
xpath="/add/doc/fie...@name='published_from_dt']"
dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss'Z'" />
But after indexing, the field value becomes like this
<date name="published_from_dt">0002-11-30T00:00:00Z</date>
I want to have the value as '0000-00-00T00:00:00Z' after indexing also.
Could anyone help on this?
PS: I am using solr 1.4.1
As 0000-00-00T00:00:00Z isn't a valid date I don't think the Solr's date
field will accept it. Assuming this is MySQL you can use the
zeroDateTimeBehavior connection string option, i.e.
mysql://user:passw...@mysqlhost/database?zeroDateTimeBehavior=convertToNull
This will make the mysql driver return those values as NULL instead of
all-zero dates.
Regards,
gwk
