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

8 votes276 views1 answer
Sql limit results returned
SQL
3 votes253 views4 answers
Mysql delete duplicate rows
SQL
0 vote263 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
4 votes405 views6 answers
Laravel jwt
SQL
0 vote227 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote262 views1 answer
How to use a trigger to validate input data
SQL
0 vote273 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
11 votes273 views1 answer
Sql query to find duplicates in column
SQL
0 vote265 views1 answer
Mysql foreach insert
SQL
2 votes233 views1 answer
Select sid oracle
SQL