Postgres, count per month

Question

Im using the followig query to get count per day ,

select count(*) as counter 
from art.pub 
WHERE createddate > CURRENT_DATE;

I want to adjust it and get it count per current month ,

any tips to adjust my query

psql is the commandline client for Postgres. mysql is a different DBMS. Which one are you using? — user330315
– user330315, Commented Nov 7, 2013 at 7:01

valex · Accepted Answer · 2013-11-07 07:08:08Z

3

In PostgreSQL try to use date_trunc

WHERE createddate >= date_trunc('month', CURRENT_DATE)

answered Nov 7, 2013 at 7:08

valex

24.2k7 gold badges47 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

code save · Accepted Answer · 2013-11-07 10:10:45Z

0

Please try this , it will work on MS Sql server

select count(*) as counter 
from  ##TBL_TEMP
WHERE DATEPART(MONTH,createddate) > DATEPART(MONTH, GETDATE());

answered Nov 7, 2013 at 10:10

code save

1,1061 gold badge9 silver badges15 bronze badges