# Epoch time fractional number

**URL:** https://discuss.elastic.co/t/epoch-time-fractional-number/366719
**Category:** Kibana
**Created:** [September 18, 2024, 9:27am UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719 "2024-09-18T09:27:27Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![miiroslavkardos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miiroslavkardos/32/123639_2.png) [@miiroslavkardos](https://discuss.elastic.co/u/miiroslavkardos)
#### Post date: [September 18, 2024, 9:27am UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719/1 "2024-09-18T09:27:27Z")

</div>

Hello guys,

I have following epoch timestamp : @timestamp":1726149789.77797

And i am using

```auto
ruby {
        code => '
            t = Time.at(event.get("@timestamp").to_f * 1000)
            event.set("@timestamp", t.strftime("%Y-%m-%d"))
        '
    }

```

but still got "\_timestampparsefailure" what am i doing wrong?

---

<div class="post-metadata">

### Author: ![miiroslavkardos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miiroslavkardos/32/123639_2.png) [@miiroslavkardos](https://discuss.elastic.co/u/miiroslavkardos)
#### Post date: [September 18, 2024, 10:04am UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719/2 "2024-09-18T10:04:22Z")

</div>

Also this is not working :

ruby { code =\> 'event.set("timestamp", event.get("@timestamp").to\_f)' }

---

<div class="post-metadata">

### Author: ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)
#### Post date: [September 19, 2024, 8:21pm UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719/3 "2024-09-19T20:21:17Z")

</div>

Thanks @miiroslavkardos, what about something like this:

```auto
ruby {
    code => '
        t = Time.at(event.get("@timestamp").to_f)
        event.set("@timestamp", t.strftime("%Y-%m-%d"))
    '
}

```

If this too similar to what you've been trying already, you could also try something like this:

```auto
ruby {
    code => '
        if event.get("@timestamp")
            event.set("timestamp", event.get("@timestamp").to_f)
        end
    '
}

```

Hope this is a good starting point here.

Best,

Jessica

---

<div class="post-metadata">

### Author: ![miiroslavkardos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miiroslavkardos/32/123639_2.png) [@miiroslavkardos](https://discuss.elastic.co/u/miiroslavkardos)
#### Post date: [September 26, 2024, 8:03am UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719/4 "2024-09-26T08:03:34Z")

</div>

> [@jessgarson](#):
>
> ```auto
> ruby {
> code => '
> if event.get("@timestamp")
> event.set("timestamp", event.get("@timestamp").to_f)
> end
> '
> }
> 
> ```

Hello Jessica,

I got error with both queries.

```auto
json - Unrecognized @timestamp value, setting current time to @timestamp, original in _@timestamp field

```

---

<div class="post-metadata">

### Author: ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)
#### Post date: [September 26, 2024, 1:15pm UTC](https://discuss.elastic.co/t/epoch-time-fractional-number/366719/5 "2024-09-26T13:15:36Z")

</div>

Thanks, @miiroslavkardos. You could try renaming the field in [source](https://stackoverflow.com/questions/45610003/logstash-unrecognized-timestamp-value-setting-current-time-to-timestamp-or) as suggested on this StackOverflow question.