Answers for "how to get last one year data in postgresql"

postgresql get last day of month

SELECT (date_trunc('month', '2017-01-05'::date) + interval '1 month' - interval '1 day')::date
AS end_of_month;

Posted by: Guest on March-05-2021

psql get last rows

# ctid represents the physical location when you don't have an ID or a DATE
SELECT * from <table_name> ORDER BY ctid DESC LIMIT <limit>;

Posted by: Guest on October-01-2021

Code answers related to "how to get last one year data in postgresql"