# Replace @timestamp with unix timestamp from MySQL

**URL:** <https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428>\
**Category:** Logstash\
**Created:** [June 6, 2017, 1:39pm UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428 "2017-06-06T13:39:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bdriss\_Sana](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@Bdriss\_Sana](https://discuss.elastic.co/u/Bdriss_Sana)\
**Post date:** [June 6, 2017, 1:39pm UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428/1 "2017-06-06T13:39:41Z")

</div>

I'm trying to inject MySQL data to Elasticsearch using Logstash.

This is my mysql table structure (id , datetime, value) where datetime consists if Unix Timestamp. ( example (131,1436298252,128) )  
And here's the configuration file I wrote but doesn't work i.e It doesn't create an index with that Unix Timestamp in the database but with real timestamps.

input {  
jdbc {

```
    jdbc_connection_string => "jdbc:mysql://localhost:3306/test"

    jdbc_user => "root"
jdbc_password => "root"

    jdbc_driver_library => "/usr/share/java/mysql-connector-java-5.1.38.jar"

    jdbc_driver_class => "com.mysql.jdbc.Driver"

    statement => "SELECT * from utinyintparamvalues"
}

```

}

filter {

```
    date {
            match => ["datetime", "MMM dd yyyy HH:mm:ss","MMM d yyyy HH:mm:ss", "ISO8601"]
         }
}

```

output {  
stdout { codec =\> json\_lines }

```
elasticsearch {
    hosts => "localhost:9200"
    index => "testts"
    document_type => "datatest"

}

```

}

How can I get it to use the timestamps from my database.? Thank you for your help.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [June 7, 2017, 10:17am UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428/2 "2017-06-07T10:17:31Z")

</div>

Does it create a field called datetime with the epoch value in it?

If so then your match pattern is wrong and you should use `EPOCH` - [https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html#plugins-filters-date-match](https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html#plugins-filters-date-match)

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 7, 2017, 11:09am UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428/3 "2017-06-07T11:09:29Z")

</div>

> If so then your match pattern is wrong and you should use EPOCH

I think you mean "UNIX".

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [June 8, 2017, 9:23pm UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428/4 "2017-06-08T21:23:44Z")

</div>

Ahh yeah, I do 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 9:24pm UTC](https://discuss.elastic.co/t/replace-timestamp-with-unix-timestamp-from-mysql/88428/5 "2017-07-06T21:24:01Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.