What does my timestamp come from the future?

Question

I'm displaying events from a PostgreSQL database, and my timestamps show as if they are going to happen in four hours..

Using select * from event in my database shows the correct timestamp. Why is rails displaying a different timestamp than what is in the database?

I would like to just show the timestamp as it is in the database.

Controller code:

ips_timestamp = event.timestamp.to_s(format = :db)

@ips_events += [timestamp: ips_timestamp]

View code:

<% @ips_events.each do |event| %>
<%= event[:timestamp] %>

You probably have a mix of `timestamp` and `timestamptz`. Details: http://stackoverflow.com/questions/9571392/ignoring-timezones-altogether-in-rails-and-postgresql/9576170#9576170 — Erwin Brandstetter, Jul 21 '14 at 20:06
I would also be willing to bet it has to do with timezones... — sethvargo, Jul 21 '14 at 20:12
My timezone is default UTC. This is only changed in `application.rb` right? — insecure-IT, Jul 21 '14 at 20:55
@ErwinBrandstetter, you where right. It was a `timestamptz` issue. Post as answer and I'll accept it. — insecure-IT, Jul 22 '14 at 11:23

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

You probably have a mix of the data types timestamp and timestamptz. Like saving a timestamp with time zone (timestamptz), but later displaying a timestamp without timezone (timestamp) or vice versa.

Details in this related answer:
Ignoring timezones altogether in Rails and PostgreSQL

edited May 23 '17 at 10:25

Community

1
1

answered Jul 22 '14 at 12:10

Erwin Brandstetter

605,456
145
1,078
1,228

What does my timestamp come from the future?

1 Answers1