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 vote159 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote209 views1 answer
SQL check if record exist
SQL
1 vote144 views4 answers
Between vs in sql
SQL
1 vote156 views1 answer
Create new table in SQL from old table with data
SQL
20 votes168 views4 answers
Reset auto increment in MySQL
SQL
51 votes255 views6 answers
Change column name sql
SQL
1 vote179 views2 answers
Limit sqlserver
SQL
0 vote148 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
3 votes146 views2 answers
Current year sql
SQL
19 votes154 views6 answers
Laravel sql query
SQL