# Logstash How to configure UTC Time according to orcal time stamp
**URL:** https://discuss.elastic.co/t/logstash-how-to-configure-utc-time-according-to-orcal-time-stamp/57567
**Category:** Logstash
**Created:** [August 9, 2016, 8:49am UTC](https://discuss.elastic.co/t/logstash-how-to-configure-utc-time-according-to-orcal-time-stamp/57567 "2016-08-09T08:49:42Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ElsayedAwd](https://discuss.elastic.co/u/ElsayedAwd)
#### Post date: [August 9, 2016, 8:49am UTC](https://discuss.elastic.co/t/logstash-how-to-configure-utc-time-according-to-orcal-time-stamp/57567/1 "2016-08-09T08:49:42Z")
I'am working with Elastic search Logstash ,catching updates from orcal data base into elastic search.
My problem ==\> how to configure sql\_last\_value UTC time parameter with orcal time stamp.
This is my configration ====\>
`input{ jdbc { . . . statement => "select * from cm.ELSAYED WHERE TIMESTAMP > :sql_last_value" } } filter { date { match => ["TIMESTAMP", "YYYY-MM-dd HH:mm:ss.ssssssssssssss Z"] target => "TIMESTAMP" timezone => "UTC" } }`
oracle time stamp is ==\> 08-AUG-16 12.26.03.796000000 PM
sql\_last\_start is ===\> 2016-08-08 14:44:22.037000000 Z
---
### Author:  [@gilisade](https://discuss.elastic.co/u/gilisade)
#### Post date: [January 1, 2017, 12:08pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-utc-time-according-to-orcal-time-stamp/57567/2 "2017-01-01T12:08:01Z")
hi
have the same problem
did you find a solution?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 4:29am UTC](https://discuss.elastic.co/t/logstash-how-to-configure-utc-time-according-to-orcal-time-stamp/57567/3 "2017-07-06T04:29:37Z")