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

1 vote364 views1 answer
Print year of a date sql
SQL
0 vote337 views1 answer
Procedures sql insert mysql
SQL
7 votes307 views1 answer
Alter table add key sql
SQL
1 vote358 views1 answer
Postgresql not in
SQL
0 vote370 views1 answer
Procedure excute monthly oracle
SQL
1 vote366 views2 answers
Sql split string by space
SQL
0 vote337 views1 answer
Get first monday of month sql
SQL
0 vote341 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote321 views1 answer
How to insert same table data using mysql query
SQL
1 vote341 views1 answer
Sql query row number group by
SQL