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 vote275 views1 answer
Create mysql pool connection python flask
SQL
0 vote290 views1 answer
Plpgsql raise notice
SQL
0 vote347 views1 answer
Oracle simple quote
SQL
6 votes282 views1 answer
Wordpress change user password sql
SQL
3 votes271 views1 answer
Ms sql skip take
SQL
3 votes274 views1 answer
Sql timestamp to date
SQL
11 votes278 views3 answers
Change column name sql server management studio
SQL
3 votes292 views1 answer
DB: in eloquent using sql
SQL
0 vote279 views1 answer
Cannot start database server xampp mac os
SQL
0 vote278 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL