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 vote152 views1 answer
Php mysqli install
SQL
5 votes175 views1 answer
Oracle get ddl
SQL
0 vote149 views1 answer
Sql server update top n records
SQL
1 vote153 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote185 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote166 views1 answer
Data types mysql vs postgresql
SQL
0 vote153 views1 answer
Recover deleted data from mysql database
SQL
0 vote145 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
5 votes169 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote183 views2 answers
Select into temp table
SQL