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 vote229 views2 answers
Sql count number of rows after group by
SQL
-1 vote242 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote282 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote227 views1 answer
How to drop function in sql
SQL
-2 votes224 views1 answer
Mysql not empty
SQL
0 vote231 views1 answer
Mysql locate
SQL
0 vote239 views1 answer
SAP Return
SQL
42 votes274 views6 answers
Rename table sql server
SQL
0 vote223 views1 answer
Mysql query to add hours to column in table
SQL
0 vote224 views1 answer
Mysql count unique in group statement
SQL