Postgresql select query where only month and year is checked from a timetamp14.09.17

https://stackoverflow.com/questions/8863156/selecting-by-month-in-postgresql

Anonymous

a python assembled query it looks like this:

sql = """                                                                                                                                                                                                                                                                  
      SELECT SUM(so._total)                                                                                                                                                                                                                                                      
      FROM shop3_order AS so                                                                                                                                                                                                                                                     
      WHERE so.status IN      ('paid_with_kasikorn','paid_with_paypal','awaiting_summary_payment','awaiting_payment')                                                                                                                                                                 
      AND  EXTRACT(MONTH FROM created_at) = '{}'                                                                                                                                                                                                                                 
      AND EXTRACT(YEAR FROM created_at) = '{}'                                                                                                                                                                                                                                   
      """.format(month,year)

14.09.17

Anonymous

Postgresql select query where only month and year is checked from a timetamp14.09.17

Information Epoch 1788982232