Following Teiid query:
is pushed as:
and returns the string representation of timestamp as:
Notice the missing space between date and time part.
SAP IQ is capable of converting the value implicitly, e.g. when I issue query
directly against SAP IQ instance, I get following string format:
The same results are returned if I use an explicit convert like:
For more formatting options see SyBooks Online