Skip to content

Instantly share code, notes, and snippets.

@Blake-

Blake-/gist:d493da28be5554a49a3a3835bbd98f05

Created March 13, 2020 15:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Blake-/d493da28be5554a49a3a3835bbd98f05 to your computer and use it in GitHub Desktop.
Save Blake-/d493da28be5554a49a3a3835bbd98f05 to your computer and use it in GitHub Desktop.
Download ZIP
Find Bad Dates In ArchivesSpace Tables
Raw
gistfile1.txt
SELECT * FROM accession WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM active_edit WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM agent_contact WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM agent_corporate_entity WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM agent_family WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM agent_person WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM agent_software WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM archival_object WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM aspace-dts_schema_info WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment_attribute WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment_attribute_definition WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment_attribute_note WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment_reviewer_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM assessment_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM auth_db WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM classification WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM classification_creator_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM classification_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM classification_term WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM classification_term_creator_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM collection_management WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM container_profile WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM custom_report_template WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM date WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM deaccession WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM default_values WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM deleted_records WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM digital_object WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM digital_object_component WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM enumeration WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM enumeration_value WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM event WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM event_link_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM extent WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM external_document WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM external_id WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM file_version WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM group WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM group_permission WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM group_user WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM instance WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM instance_do_link_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM job WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM job_created_record WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM job_input_file WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM job_modified_record WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM linked_agent_term WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM linked_agents_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM location WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM location_function WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM location_profile WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM location_profile_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM name_authority_id WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM name_corporate_entity WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM name_family WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM name_person WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM name_software WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM note WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM note_persistent_id WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM notification WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM oai_config WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM owner_repo_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM permission WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM preference WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rde_template WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM related_accession_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM related_agents_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM repository WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM required_fields WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_delete WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_ WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_ao WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_do WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_do_ao WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_doc WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_doc_do_ao WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_update_via_r WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM resource_updates_schema_info WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM revision_statement WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rights_restriction WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rights_restriction_type WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rights_statement WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rights_statement_act WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM rights_statement_pre_088 WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM schema_info WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM sequence WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM session WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM spawned_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM sub_container WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM subject WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM subject_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM subject_term WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM subnote_metadata WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM surveyed_by_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM system_event WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM telephone WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM term WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM top_container WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM top_container_housed_at_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM top_container_link_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM top_container_profile_rlshp WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM user WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM user_defined WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM vocabulary WHERE user_mtime LIKE '2020-03-08 02:00%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment