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 vote341 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
1 vote392 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
2 votes376 views1 answer
Select sid oracle
SQL
1 vote351 views1 answer
Increase existing date in sql oracle
SQL
-1 vote343 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote377 views1 answer
Oracle plsql sleep
SQL
0 vote374 views1 answer
Sql change primary key to composite key
SQL
0 vote345 views2 answers
Database owner can't create new tables postgres
SQL
0 vote383 views1 answer
Psql get table data types
SQL
10 votes354 views2 answers
Sql merge statement
SQL