SF.net SVN: ledger-smb:[2912] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2912
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2912&view=rev
Author:   einhverfr
Date:     2010-02-24 22:16:18 +0000 (Wed, 24 Feb 2010)

Log Message:
-----------
Attempt to fix casting errors caused by doy fix

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-02-24 22:11:58 UTC (rev 2911)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-02-24 22:16:18 UTC (rev 2912)
@@ -48,8 +48,8 @@
                                                  ai.purchase_date::timestamp))
                                               - (max(rep.report_date)
                                               - coalesce(
-                                                 ai.start_depreciation::timestamp,
-                                                 ai.purchase_date::timestamp))::numeric / 365
+                                                 ai.start_depreciation,
+                                                 ai.purchase_date))::numeric / 365
                                         END)::numeric,
                                             
                                    coalesce(


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