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 vote136 views1 answer
Write SQL in ruby on rails
SQL
2 votes118 views1 answer
Mariadb json select
SQL
8 votes110 views1 answer
Mac restore mysql database command line
SQL
0 vote123 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
4 votes142 views1 answer
Mysql store ip address
SQL
0 vote159 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote122 views1 answer
Top frequency in sql server
SQL
0 vote118 views1 answer
Sql select first and last record of each group
SQL
1 vote123 views1 answer
Mysql backup skip table
SQL
18 votes112 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL