How to compare dates in datetime fields in Postgresql?

by

@Nicolai is correct about casting and why the condition is false for any data. i guess you prefer the first form because you want to avoid date manipulation on the input string, correct? you don’t need to be afraid:

SELECT *
FROM table
WHERE update_date >= '2013-05-03'::date
AND update_date < ('2013-05-03'::date + '1 day'::interval);

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. How to implement a many-to-many relationship in PostgreSQL?
  3. How to update selected rows with values from a CSV file in Postgres?
  4. Optimise PostgreSQL for fast testing
  5. How to delete duplicate rows without unique identifier
  6. Best way to check for “empty or null value”
  7. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  8. PostgreSQL parameterized Order By / Limit in table function
  9. How can I send email from PostgreSQL trigger?
  10. How do you do date math that ignores the year?
  11. Getting date list in a range in PostgreSQL
  12. NOT NULL constraint over a set of columns
  13. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  14. How do I alter the position of a column in a PostgreSQL database table?
  15. PostgreSQL: how to convert from Unix epoch to date?
  16. Query that ignore the spaces
  17. Continuing a transaction after primary key violation error
  18. Use email address as primary key?
  19. Bulk/batch update/upsert in PostgreSQL
  20. sqlite select with condition on date
  21. SQL query to find record with ID not in another table
  22. Postgres Error: More than one row returned by a subquery used as an expression
  23. Grant privileges for a particular database in PostgreSQL
  24. Upsert with a transaction
  25. Getting results between two dates in PostgreSQL
  26. PostgreSQL how to create a copy of a database or schema?
  27. Temporal database design, with a twist (live vs draft rows)
  28. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  29. Query for count of distinct values in a rolling date range
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment