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

2 votes330 views2 answers
Mysql search for column name in all tables
SQL
1 vote349 views1 answer
Backup mysql schema only
SQL
0 vote378 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote347 views1 answer
Create table split string function in sql server
SQL
5 votes309 views1 answer
How to check port number for postgresql
SQL
0 vote342 views1 answer
Get clob size oracle
SQL
0 vote314 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote301 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote335 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
-1 vote311 views1 answer
Add column alter table default value
SQL