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 vote362 views1 answer
Check user sql password from command line
SQL
4 votes399 views4 answers
Check constraint in ms sql
SQL
5 votes332 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote328 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote338 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
3 votes344 views2 answers
Current year sql
SQL
1 vote353 views1 answer
Postgres check blocking
SQL
2 votes358 views2 answers
Get all tables using like
SQL
1 vote323 views1 answer
Oracle sql create or replace view
SQL
0 vote427 views1 answer
Sqlite display headers on columns
SQL