On Fri, Jun 20, 2014 at 3:42 PM, Arup Rakshit <arupraks...@rocketmail.com> wrote: > How can I get first day date of the previous month. Last day of previous > month can be found using the answer - > http://stackoverflow.com/a/8945281/2767755 Here is how to get the first day date of the previous month: =# select date_trunc('month', now()) - interval '1 month' as last_month; last_month ------------------------ 2014-05-01 00:00:00+09 (1 row) -- Michael
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
