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

6 votes341 views2 answers
Mysql set primary key
SQL
0 vote349 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
-2 votes368 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote349 views1 answer
Add multiple field in table sql
SQL
1 vote348 views1 answer
Pagination sql
SQL
0 vote382 views1 answer
Updating database in sql
SQL
0 vote347 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
2 votes419 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote349 views1 answer
Reset postgresql password windows
SQL
0 vote350 views1 answer
Function sum(text) does not exist postgres
SQL