Capital_Assets table

Column Type

Id

String

Url

URI

View

String

Created_At

Timestamp

Description

String

Asset_Type

String

Asset_Life_Years

Integer

Purchased_On

String

Updated_At

Timestamp

Depreciation_Profile_Method

String

Depreciation_Profile_Asset_Life_Years

Integer

Depreciation_Profile_Frequency

String

Examples

SELECT
    TIMESTAMPADD (SQL_TSI_YEAR, Asset_Life_Years, Created_At) as EndOfDep,
    ca.*
FROM
    Capital_Assets ca
WHERE
    TIMESTAMPADD (SQL_TSI_YEAR, Asset_Life_Years, Created_At) > Current_Timestamp