How to get the count of current month Sunday’s in psql?

by

You need EXTRACT:

SELECT 
    EXTRACT(DOW FROM DATE '2011-02-16') = 0; -- 0 is Sunday

This can result in true or false, it’s a sunday or it’s not. I have no idea what you mean by “total number” because that will always be 0 (the date is not a sunday) or 1 (the given data is a sunday).

Edit: Something like this?

SELECT 
    COUNT(*)
FROM
    generate_series(timestamp '2011-01-01', '2011-03-01', '1 day') AS g(mydate)
WHERE
    EXTRACT(DOW FROM mydate) = 0;

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. postgres default timezone
  7. Adding ‘serial’ to existing column in Postgres
  8. How to export table as CSV with headings on Postgresql?
  9. How to persist data in a dockerized postgres database using volumes
  10. Time zone names with identical properties yield different result when applied to timestamp
  11. Permission denied for relation
  12. CONSTRAINT to check values from a remotely related table (via join etc.)
  13. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  14. Execute a dynamic crosstab query
  15. Copy a table from one database to another in Postgres
  16. User defined variables in PostgreSQL
  17. Postgres query optimization (forcing an index scan)
  18. psql: FATAL: database “” does not exist
  19. Postgres FOR LOOP
  20. Omitting the double quote to do query on PostgreSQL
  21. Storing Images in PostgreSQL
  22. Strange behaviour in Postgresql
  23. Postgres: Distinct but only for one column
  24. In PostgreSQL, how to insert data with COPY command?
  25. Cursor based records in PostgreSQL
  26. How to add column if not exists on PostgreSQL?
  27. Configuration parameter work_mem in PostgreSQL on Linux
  28. How to work with PGpoint for Geolocation using PostgreSQL?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment