Is ISO8601 the best date-format for PostgreSQL jsonb when i want to filter by the date?
|Added at||2016-11-16 09:11|
I'm new to PostgreSQL and I have the following question:
I have a table with just an id-column and a data-column, which uses the jsonb-type. Inside the jsonb-object I have a datetime field. I read in various posts, that I should use the ISO-8601 dateformat to store in the DB.
I want to filter my table by date like this:
Is this really the best date-format for this purpose?
Thanks in advance :)