Check whether string is a date Postgresql

by

You can create a function:

create or replace function is_date(s varchar) returns boolean as $$
begin
  perform s::date;
  return true;
exception when others then
  return false;
end;
$$ language plpgsql;

Then, you can use it like this:

postgres=# select is_date('January 1, 2014');
 is_date
---------
 t
(1 row)

postgres=# select is_date('20140101');
 is_date
---------
 t
(1 row)

postgres=# select is_date('20140199');
 is_date
---------
 f
(1 row)

More Related Contents:

  1. How do you do date math that ignores the year?
  2. Getting date list in a range in PostgreSQL
  3. PostgreSQL: how to convert from Unix epoch to date?
  4. How to compare dates in datetime fields in Postgresql?
  5. Postgresql query between date ranges
  6. Getting results between two dates in PostgreSQL
  7. Query for count of distinct values in a rolling date range
  8. How to return result of a SELECT inside a function in PostgreSQL?
  9. Possible to perform cross-database queries with PostgreSQL?
  10. Reset auto increment counter in postgres
  11. Optimize query with OFFSET on large table
  12. GROUP BY and aggregate sequential numeric values
  13. Safely rename tables using serial primary key columns
  14. How to use (install) dblink in PostgreSQL?
  15. get JOIN table as array of results with PostgreSQL/NodeJS
  16. How can I send email from PostgreSQL trigger?
  17. Postgres manually alter sequence
  18. What’s the proper index for querying structures in arrays in Postgres jsonb?
  19. Postgres sql insert query syntax error from phpPgAdmin
  20. SQL ORDER BY date problem
  21. Combine two columns and add into one new column
  22. Bulk/batch update/upsert in PostgreSQL
  23. Grant privileges for a particular database in PostgreSQL
  24. Check if NULL exists in Postgres array
  25. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  26. Return rows from INSERT with ON CONFLICT without needing to update
  27. Insert data and set foreign keys with Postgres
  28. Select query with date condition
  29. Oracle Convert TIMESTAMP with Timezone to DATE
  30. How to use a ring data structure in window functions

Leave a Comment