SF.net SVN: ledger-smb: [1515] branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2. 6.19.sql

[..hidden..]

Revision: 1515
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1515&view=rev
Author:   einhverfr
Date:     2007-09-05 18:02:25 -0700 (Wed, 05 Sep 2007)

Log Message:
-----------
Adding date format conversion to upgrade script.

Modified Paths:
--------------
    branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql

Modified: branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
===================================================================
--- branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql	2007-09-06 00:05:23 UTC (rev 1514)
+++ branches/1.2/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql	2007-09-06 01:02:25 UTC (rev 1515)
@@ -191,7 +191,7 @@
 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' 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.