Answers for "get last month value in postgres"

SQL
0

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
-1

postgres get last value

select last_value("name") over(order by created_at desc) as name from profile
Posted by: Guest on April-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language