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 votes299 views1 answer
Postgresql transaction
SQL
1 vote315 views1 answer
Raise application error in oracle
SQL
3 votes306 views2 answers
To_char oracle
SQL
5 votes350 views1 answer
Oracle drop index if exists
SQL
0 vote287 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote315 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote296 views1 answer
Order by number of character in sql
SQL
0 vote297 views1 answer
Display first three characters sql
SQL
0 vote270 views1 answer
Select all domains of database firbird
SQL
0 vote290 views1 answer
Sql select column names starting with
SQL