Convert geo date to timestamp in pep-db

[khoroshevskyi]

It would be nice to have last update date in db for GEO, actual last update date.
How to do it?

[khoroshevskyi]

1. To select and convert series_last_update_date to timestamp using SQL us this command:

select TO_TIMESTAMP((((config->>'experiment_metadata')::json)->>'series_last_update_date'), 'MON DD YYYY') from projects where namespace='geo' limit 20;

To select serie_submission_date:

select TO_TIMESTAMP((((config->>'experiment_metadata')::json)->>'series_submission_date'), 'MON DD YYYY') from projects where namespace='geo' limit 20;

To populate last update date with actual values:

UPDATE projects SET submission_date = (select TO_TIMESTAMP((((config->>'experiment_metadata')::json)->>'series_submission_date'), 'MON DD YYYY')) where namespace='geo';

UPDATE projects SET last_update_date = (select TO_TIMESTAMP((((config->>'experiment_metadata')::json)->>'series_last_update_date'), 'MON DD YYYY')) where namespace='geo';