D
D
des1roer2015-01-13 07:31:21
PostgreSQL
des1roer, 2015-01-13 07:31:21

Getting an interval in a digestible form?

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?

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)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question