Postgresql between month

WHERE date >= DATE '2012-01-01' 
  AND date < DATE ('2013-04-01' + INTERVAL '1 MONTH')

Source: stackoverflow.com

Postgresql between month

CREATE OR REPLACE FUNCTION public.fn_getlastofmonth (
  date
)
RETURNS date AS
$body$
begin
    return (to_char(($1 + interval '1 month'),'YYYY-MM') || '-01')::date - 1;
end;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;
--------------------------------------------------------------------------------
WHERE date >= '2012-01-01' 
  AND date < fn_getlastofmonth('2013-04-01')

Source: stackoverflow.com

Postgresql between month

WHERE date >= DATE '2012-01-01' 
  AND date < DATE '2013-05-01'      --- first date of the next month

Source: stackoverflow.com

Postgresql between month

CREATE OR REPLACE FUNCTION public.fn_getlastofmonth (
  date
)
RETURNS date AS
$body$
begin
    return (to_char(($1 + interval '1 month'),'YYYY-MM') || '-01')::date - 1;
end;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;

Source: stackoverflow.com

Similar codes

0 vote104 views1 answer
Java mysql date format
SQL
1 vote121 views1 answer
Create sqlite database in laravel
SQL
10 votes95 views3 answers
Join multiple tables sql
SQL
-1 vote137 views5 answers
Left join sql
SQL
0 vote107 views1 answer
Check connections to database postgres
SQL
1 vote102 views1 answer
Cross schema query oracle 2 users
SQL
3 votes111 views2 answers
Df to sql pandas sql achemy
SQL
0 vote150 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote110 views1 answer
Mysql select where field like in list
SQL
2 votes102 views1 answer
Sql find missing values between two tables
SQL