How do I know how many hours have passed between the value of Timestamp and the present in Postgresql?

I am using Postgresql DB. I want to read the created_at column value and check how many hours of row it was created.

select  EXTRACT(HOUR FROM (NOW() - created_at)) as age
from table

The prices are coming out weird like this.

postgresql timestamp

2022-09-21 21:24

1 Answers

This is because the EXTRACT function only takes the part corresponding to the time from the difference between the current time and created_at. For example, if the difference is 20 hours and 35 minutes a day, it's 20.

To make a difference from the current time, you can:

SELECT (EXTRACT(EPOCH FROM NOW() - created_at)/3600)::Integer AS hours
FROM table

Note: http://www.postgresql.org/docs/current/static/functions-datetime.html

2022-09-21 21:24

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656