With the "timezone" parameter, you can adjust the timezone used by JDBC
plugin in accordance to the timezone of the DB it connects to.
E.g. for PST
"timezone" : "America/Los Angeles"
Jörg
On Mon, Apr 6, 2015 at 7:13 AM, <phani.nadimi...@goktree.com> wrote:
> Hi Jorg,
>
> yes mysql and es servers are running in different timezones.
>
> mysql running in PST timezone where as es servers running on CDT
> timezone.
>
> Thanks
> phani
>
> On Friday, April 3, 2015 at 8:14:00 PM UTC+5:30, Jörg Prante wrote:
>>
>> Do you run MySQL and ES in different timezones?
>>
>> Jörg
>>
>> On Fri, Apr 3, 2015 at 2:47 PM, <phani.n...@goktree.com> wrote:
>>
>>> Hi All,
>>>
>>> I have important scenario to share with you regarding mysql river.
>>>
>>> I created index it contains date field no format was specified.
>>>
>>> the following is the mapping :
>>>
>>> "created" :{
>>> "type" : "date",
>>> "format" : "dateOptionalTime"
>>> }
>>> when I index data using river the date is inserting in the following
>>> format : "2015-03-06T18:04:15.000-06:00" automatically.
>>> due to this I am getting my daily record counts. but if the date
>>> format is 2015-03-06T18:04:15.000Z like this it is working fine and showing
>>> daily counts fine
>>> But from database my date is coming like this '2015-03-01 00:00:00' So
>>> how can we control the date from river while indexing in to elasticsearch
>>> which should be display in 2015-03-06T18:04:15.000Z format.
>>> please suggest me on this due to this my monthly sales also not
>>> showing correctly.is there any custom date format need to define when
>>> data is populating
>>> using river from database.
>>> why "-06:00" this is appending at the end of each date please explain
>>> me this concept?please help me in this
>>>
>>> Thanks
>>> phani
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "elasticsearch" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to elasticsearc...@googlegroups.com.
>>> To view this discussion on the web visit https://groups.google.com/d/
>>> msgid/elasticsearch/190963a8-df42-4026-9fff-5dacecce8590%
>>> 40googlegroups.com
>>> <https://groups.google.com/d/msgid/elasticsearch/190963a8-df42-4026-9fff-5dacecce8590%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to elasticsearch+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/9610caa8-9b76-4d8d-aca6-6eec5b6afea3%40googlegroups.com
> <https://groups.google.com/d/msgid/elasticsearch/9610caa8-9b76-4d8d-aca6-6eec5b6afea3%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAKdsXoEDeAtJTc_XGSmBaMKwA9%3D67P7%3DtBu3sQdzVnWupC1%2BJg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
