Answers for "postgres last month"

last 6 months postgresql

CURRENT_DATE - INTERVAL '6 months'

Posted by: Guest on April-01-2020

postgresql get last day of month

create function end_of_month(date)
returns date as
$$
select (date_trunc('month', $1) + interval '1 month' - interval '1 day')::date;
$$ language 'sql'
immutable strict;

Posted by: Guest on March-05-2021

Code answers related to "postgres last month"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres last month"

Code answers related to "postgres last month"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres last month"

Code answers related to "postgres last month"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us