From 564b77c84e38ff7b6f50a61a4c4c42b9d54e15e8 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 24 Mar 2015 16:17:16 -0400 Subject: [PATCH] handle dates like 051980 Signed-off-by: Jason Etheridge --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index c99f6f1..a724832 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -646,7 +646,7 @@ CREATE OR REPLACE FUNCTION migration_tools.attempt_date (TEXT,TEXT) RETURNS DATE output DATE; BEGIN FOR output IN - EXECUTE 'SELECT ' || quote_literal(attempt_value) || '::date AS a;' + EXECUTE 'SELECT ' || quote_literal(REGEXP_REPLACE(attempt_value,'^(\d\d)(\d\d)(\d\d)$','\1-\2-\3')) || '::date AS a;' LOOP RETURN output; END LOOP; -- 1.7.2.5