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

-1 vote301 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote309 views1 answer
Mysql last friday of current month
SQL
10 votes301 views4 answers
Drop primary key
SQL
0 vote299 views2 answers
How to install mssql on mac
SQL
1 vote291 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote275 views1 answer
Insufficient memory to excute the sql query
SQL
-1 vote276 views1 answer
How to open blade file from blade in laravel
SQL
36 votes310 views3 answers
Add column in mysq
SQL
0 vote295 views1 answer
List all permissions on a table in postgres
SQL
2 votes294 views1 answer
Mysql last 7 days including today
SQL