# How to create file that contain tracking\_column date

**URL:** https://discuss.elastic.co/t/how-to-create-file-that-contain-tracking-column-date/323846
**Category:** Logstash
**Tags:** elastic-stack-sql
**Created:** [January 24, 2023, 3:01pm UTC](https://discuss.elastic.co/t/how-to-create-file-that-contain-tracking-column-date/323846 "2023-01-24T15:01:42Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![odelacruzc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/odelacruzc/32/48992_2.png) [@odelacruzc](https://discuss.elastic.co/u/odelacruzc)
#### Post date: [January 24, 2023, 3:01pm UTC](https://discuss.elastic.co/t/how-to-create-file-that-contain-tracking-column-date/323846/1 "2023-01-24T15:01:42Z")

</div>

Hi, please your help, I have a pipeline with input JDBC so I work with tracking\_colum, I have a file .sql\_last\_value\_date with this format: --- !ruby/object:DateTime '2022-07-01 05:00:00.000000000 Z'

this the date that I want to get information from BD, this format is good? Because my pipeline don't work with this date T\_T

---

<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: [February 21, 2023, 3:02pm UTC](https://discuss.elastic.co/t/how-to-create-file-that-contain-tracking-column-date/323846/2 "2023-02-21T15:02:38Z")

</div>

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