From 380735c947921d2be66f4523cd0e0142d93e28b3 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Thu, 6 Sep 2007 01:02:25 +0000
Subject: Adding date format conversion to upgrade script.

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1515 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/legacy')

diff --git a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
index 77cf424c..020738a1 100644
--- a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
+++ b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
@@ -191,7 +191,7 @@ SELECT 'version', '1.2.0'::text
 UNION
 SELECT 'curr', curr::text FROM old_defaults
 UNION
-SELECT 'closedto', closedto::text FROM old_defaults
+SELECT 'closedto', to_char(closedto, 'YYYY-MM-DD') FROM old_defaults
 UNION
 SELECT 'revtrans', (CASE WHEN revtrans IS NULL THEN NULL
 			WHEN revtrans THEN '1' 
-- 
cgit v1.2.3