time comparision in rails for postgresql

Question

I have a column name late with datatype time without time zone. my requirement is to read all the rows which is late more than by 1 hours. I have to query through my rails application. In table column value is like 00:31:00 but in rails it is like 2000-01-01 00:31:00 UTC. How to query directly or by using ActiveRecords?

RAM · Accepted Answer · 2012-11-01 09:58:12Z

1

When you can directly access the time in rails as '2000-01-01 00:31:00 UTC', then use the code

require 'time'
standard_time_for_comparison = '2000-01-01 00:31:00 UTC'
(Time.now - Time.parse(standard_time_for_comparison))/3600 > 1

Change standard_time_for_comparison according to your needs.

answered Nov 1, 2012 at 9:58

RAM

2,4191 gold badge24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

time comparision in rails for postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related