postgresqlHow can I retrieve data from PostgreSQL for yesterday's date?
The following example code block can be used to retrieve data from PostgreSQL for yesterday's date:
SELECT *
FROM table_name
WHERE date_column = CURRENT_DATE - INTERVAL '1 day';
This statement will select all data from the specified table with a date value equal to yesterday's date.
The parts of the code are:
SELECT *
- This selects all columns from the specified table.FROM table_name
- This specifies the table from which the data should be retrieved.WHERE date_column = CURRENT_DATE - INTERVAL '1 day'
- This specifies the condition for selecting data from the table where the date column is equal to yesterday's date.
Helpful links
More of Postgresql
- How do I parse XML data using PostgreSQL?
- How can Zalando use PostgreSQL to improve its software development?
- How can I use PostgreSQL XOR to compare two values?
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can I use PostgreSQL's "zero if null" feature?
- How can I use PostgreSQL with YAML?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How do I use the PostgreSQL XML type?
- How can I convert XML data to a PostgreSQL table?
- How do I set the PostgreSQL work_mem parameter?
See more codes...