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 votes188 views2 answers
Select multiple tables mysql
SQL
0 vote235 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote212 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
4 votes195 views1 answer
Mysql biginteger size
SQL
0 vote190 views1 answer
Sql counter column
SQL
0 vote207 views1 answer
Except in sql alchemy
SQL
0 vote191 views1 answer
How to select only a certain date sql
SQL
5 votes189 views1 answer
Commentaire table oracle
SQL
7 votes187 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote186 views1 answer
Cross apply top for each row t1
SQL