On Sat, Jun 21, 2014 at 12:54 PM, Arup Rakshit
arupraks...@rocketmail.com wrote:
One suggestion I need from you. Would it be a good to start straight from
doco, or should I start from a book ?
It depends on what you are looking for and what you want to learn, but
personally, as the documentation
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
Regards,
Arup Rakshit
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:
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
On 20 June 2014 09:11, Arup Rakshit arupraks...@rocketmail.com wrote:
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
On 06/20/2014 12:11 AM, Arup Rakshit wrote:
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
On 21/06/14 03:12, Steve Crawford wrote:
On 06/20/2014 12:11 AM, Arup Rakshit wrote:
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
On Friday, June 20, 2014 08:12:14 AM you wrote:
Welcome. And yes, it is awesome.
I agree.
Being new to the DB
No. I worked on Oracle DB earlier days(approx 2 years). But pgsql just 1
month.
and mailing list,
please note that the convention on all PostgreSQL mailing lists is to
post your