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.