I need to store ISO 8601 recurrence (something like R/20130325T06/P1D) to a table. this table stores different recurring jobs that needs to be executed.
Is there any native data type mysql (or any other db for the knowledge) that can be used to store this data other than VARCHAR data type.
VARCHAR
. If you need to get the date/time/etc, then you are on your own. Nothing in MySQL understands ISO 8601. – Rick James Apr 15 '20 at 5:32