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 votes210 views1 answer
Create trigger syntax
SQL
0 vote219 views1 answer
Except in sql
SQL
10 votes206 views4 answers
Sql pagination
SQL
0 vote238 views1 answer
Mysql relationships between tables
SQL
0 vote193 views1 answer
Oracle query archivemode
SQL
-1 vote203 views1 answer
Su: Authentication failure mysql
SQL
1 vote215 views1 answer
Sqlite update from another table
SQL
1 vote222 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote196 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote189 views1 answer
Sql developer export connections
SQL