How to list records with date from the last 10 days

Question

SELECT Table date FROM Table WHERE date  gt  current date - 10    Does this work on PostgreSQL

User · Answer

Just generalising the query if you want to work with any given date instead of current date  SELECT Table date   FROM Table    WHERE Table date  gt   2020-01-01   date - interval  10 day

User · Answer

I would check datatypes   current date has  date  datatype  10 is a number  and Table date - you need to look at your table

User · Answer

you can use between too   SELECT Table date   FROM Table    WHERE date between current date and current date - interval  10 day

User · Answer

Yes this does work in PostgreSQL  assuming the column  date  is of datatype date  Why don t you just try it   The standard ANSI SQL format would be    SELECT Table date  FROM Table  WHERE date  gt  current date - interval  10  day    I prefer that format as it makes things easier to read  but it is the same as current date - 10

User · Answer

http   www postgresql org docs current static functions-datetime html shows operators you can use for working with dates and times  and intervals    So you want  SELECT  date  FROM  Table  WHERE  date   gt   CURRENT DATE - INTERVAL  10 days      The operators functions above are documented in detail    CURRENT DATE INTERVAL  10 days

User · Answer

My understanding from my testing  and the PostgreSQL dox  is that the quotes need to be done differently from the other answers  and should also include  day  like this   SELECT Table date   FROM Table    WHERE date  gt  current date - interval  10 day     Demonstrated here  you should be able to run this on any Postgres db    SELECT DISTINCT current date                   current date - interval  10  day                   current date - interval  10 days     FROM pg language    Result   2013-03-01  2013-03-01 00 00 00 2013-02-19 00 00 00

[sql] How to list records with date from the last 10 days?

Examples related to sql

Examples related to postgresql