Getting an interval in a digestible form?

D

des1roer2015-01-13 07:31:21

PostgreSQL

des1roer, 2015-01-13 07:31:21

I want to check when the last entry was made in the database.
query
SELECT localtimestamp - "F_Date"
comes something like 00:00:09.454646
how to get rid of microseconds at the end?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

krypt3r, 2015-01-13
@des1roer

SELECT (localtimestamp - "F_Date")::interval(0)

Similar questions

B

Bogdan2018-01-30 15:12:38

Adding and updating records via Insert Into? 1Reply

C

Creatizmo2010-01-01 20:33:49

What database administration software do you use? 15Reply

R

Rick2018-02-01 20:37:31

How to bypass duplicate tables when running an application in a container? 1Reply

E

EVOSandru62015-09-30 06:22:32

How to make dynamic limit in postgres query? 1Reply

E

EVOSandru62020-04-19 02:13:50

How to migrate node-pg-migrate using a specific migrations-dir path? 1Reply

Didn't find what you were looking for?

Ask your question