Re: Storing MYSQL DATETIME field in solr as String

2014-01-23 Thread tariq
Hello manju, Thank you! It's really helpful for me. -- View this message in context: http://lucene.472066.n3.nabble.com/Solved-Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4112977.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2014-01-23 Thread manju16832003
Hi Tariq, I'm glad that helped you :-). Thanks -- View this message in context: http://lucene.472066.n3.nabble.com/Solved-Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4112979.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2014-01-06 Thread manju16832003
2013-11-13 10:26:32 2013-11-13 10:26:32 This is exactly what I was looking for. If you guys have any other wise please free to share. :-). Happy Solr!!! -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4109720.html

Re: Storing MYSQL DATETIME field in solr as String

2013-12-17 Thread manju16832003
> > http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4107138.html > To unsubscribe from Storing MYSQL DATETIME field in solr as String, click > here<http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&n

Re: Storing MYSQL DATETIME field in solr as String

2013-12-17 Thread Raymond Wiker
On 17 Dec 2013, at 17:30 , manju16832003 wrote: > Hi Raymond, > You mean during the DIH execution? Yes; as part of the sql statement.

Re: Storing MYSQL DATETIME field in solr as String

2013-12-17 Thread manju16832003
Hi Shekhar, Yes :-). Thanks for the references. Will try out the options you mentioned. Thanks -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4107135.html Sent from the Solr - User mailing list archive at

Re: Storing MYSQL DATETIME field in solr as String

2013-12-17 Thread manju16832003
Hi Raymond, You mean during the DIH execution? -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4107136.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2013-12-16 Thread Raymond Wiker
uot; locale="en"/> > > > > schema.xml > > > multiValued="false" default="NOW" /> > > > > Output is > > 2012-12-05T07:38:27Z > > > > *Scenario - 3* > > dih.xml (aka data-config.xml) > > >

Re: Storing MYSQL DATETIME field in solr as String

2013-12-16 Thread Shalin Shekhar Mangar
is > 2012-12-05T07:38:27Z > > *Scenario - 3* > dih.xml (aka data-config.xml) > > transformer="DateFormatTransformer"> > > xpath="/RDF/item/date" dateTimeFormat="<b>-MM-dd > HH:mm:ss*" locale="en"/> > >

Re: Storing MYSQL DATETIME field in solr as String

2013-12-16 Thread manju16832003
MM-dd HH:mm:ss*" locale="en"/> schema.xml Output is Thu Dec 05 15:38:27 MYT 2013 My expectation was *2012-12-05 07:38:27* (MySQL DateTime format) -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4106854.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2013-12-15 Thread manju16832003
y applying DateFormatTransformer. No luck :-(. -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4106852.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2013-12-15 Thread Shalin Shekhar Mangar
On Mon, Dec 16, 2013 at 12:38 PM, manju16832003 wrote: > Hi Shekhar, > Thanks for replying :-). > Yes your answer is justifiable. > DateFormatTransformer was a good consideration. However it doesn't out the > format I expected. Rather it outputs in the following manner > > Tue Jun 05 00:00:00 MYT

Re: Storing MYSQL DATETIME field in solr as String

2013-12-15 Thread manju16832003
s way *-- without having 'T'* Output is the same :-) I expected date format to be *-MM-dd HH:mm:ss* -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4106849.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Storing MYSQL DATETIME field in solr as String

2013-12-15 Thread Shalin Shekhar Mangar
the behaviour of Solr? is there a reason behind that? > > Thanks > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836.html > Sent from the Solr - User mailing list archive at Nabble.com. -- Regards, Shalin Shekhar Mangar.

Storing MYSQL DATETIME field in solr as String

2013-12-15 Thread manju16832003
hanks -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836.html Sent from the Solr - User mailing list archive at Nabble.com.