Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I get first day date of the previous month ? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: How can I get first day date of the previous month ?
Date
Msg-id 1403248261.1640.YahooMailNeo@web193901.mail.sg3.yahoo.com
Whole thread Raw
In response to Re: How can I get first day date of the previous month ?  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: How can I get first day date of the previous month ?
Re: How can I get first day date of the previous month ?
List pgsql-general
Tree view
Thanks for your answer. How to get the first day date of last 6 months from now then will be :

yelloday_development=# select date_trunc('month', now()) - interval '5 month' as first_month;
        first_month        
---------------------------
 2014-01-01 00:00:00+05:30
(1 row)

Is it correct ? I am new pgdql DB :-) Awesome DB it is... 
 
Regards,
Arup Rakshit


On Friday, 20 June 2014 12:22 PM, Michael Paquier <michael.paquier@gmail.com> wrote:


On Fri, Jun 20, 2014 at 3:42 PM, Arup Rakshit

<aruprakshit@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



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: How can I get first day date of the previous month ?
Next
From: Dick Kniep
Date:
Subject: Strange Error in postgresql 8.4