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 vote275 views1 answer
Create domain sql
SQL
5 votes288 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote287 views1 answer
Postgres in operator with comma separated values
SQL
2 votes285 views1 answer
Anonymous block plsql
SQL
2 votes293 views1 answer
Set boolean flasksql
SQL
0 vote283 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
17 votes295 views6 answers
Sql select distinct
SQL
1 vote287 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote305 views1 answer
Resullt all update knex mysql
SQL
0 vote282 views2 answers
Mysql multiply
SQL