Date Conversions - EcoSys - Customization & Programming - Hexagon

EcoSys Gateway Web Service API Client

Language
English
Product
EcoSys
Search by Category
Customization & Programming
EcoSys Version
8.7

The date format required for the EcoSys REST API is ISO-8601.

It is easier to embed the date format conversion into the query itself. To do this, wrap any date columns in the query string inside a conversion function.

Following are some examples, assuming you are selecting the column "cost_date", and want it int ISO-8601 format using the alias "CostDate":

Oracle

SELECT TO_CHAR( cost_date, 'YYYY-MM-DD') "CostDate" FROM ...

SQL Server

SELECT CONVERT( VARCHAR(10), cost_date, 126 ) "CostDate" FROM ...

You can also use the native database date output format, and apply conversion patterns for those attributes. For more information, see Date Formats.