Problem: I have to set IntervalStyle in separate statement to convert
interval type to ISO8601 string.
This isn't well supported by ORMs or similar tools, requiring us to
set it globally (per role or per database).
Problem #2 (exotic): you can't mix two output styles in a single query.
Proposed
are implemented in:
- SQL Server (as TRY_CONVERT)
- Oracle (as CONVERT([val] DEFAULT [expr] ON CONVERSION ERROR)
I would love to implement it myself, but my knowledge of C is superficial.
Thanks,
Michał Wadas