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 use PostgreSQL's XMLTABLE to parse XML data?
- How do I use PostgreSQL's XMIN and XMAX features?
- How do I set the PostgreSQL work_mem parameter?
- How do I use PostgreSQL with Qt?
- How do I use PostgreSQL's ON CONFLICT DO NOTHING clause?
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How do I export data from PostgreSQL to an XML file?
- How can I use PostgreSQL for my project?
- How can I use PostgreSQL substring functions?
- How do I create a PostgreSQL trigger?
See more codes...