how to get all entries with a timestamp sooner than last 24hours?

Asked Jul 28 '22 at 19:05

Active Jul 28 '22 at 19:57

Viewed 17 times

How to get last 24h entries based on linux timestamp in seconds ? like 1658754064 for example.

I tried

  SELECT * from some_table
  WHERE timestamp::DATE > (CURRENT_DATE - INTERVAL '1 day')

but I get cannot cast type bigint to date error.

edited Jul 28 '22 at 19:57

asked Jul 28 '22 at 19:05

François Richard

Apparently your column named `timestamp` isn't a timstamp, but a `bigint`. – Jul 28 '22 at 19:41
yes thanks, 'timestamp' is not the right term for psql indeed – François Richard Jul 28 '22 at 19:47
1

https://blog.sql-workbench.eu/post/epoch-mania/ – Jul 28 '22 at 19:57

0 Answers0