diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-09-06 01:02:25 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-09-06 01:02:25 +0000 |
| commit | 380735c947921d2be66f4523cd0e0142d93e28b3 (patch) | |
| tree | c3fcf7df73d923599ab541d61963b4440e3c016b /sql | |
| parent | 4dde7266bd8643fa6477dbd0fcffeb59e61dc645 (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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' |