We just updated to Exasol version 7.0.3, that now supports ISO8601/JSON
style timestamp format with T/Z characters. 😃It works fine with
TO_TIMESTAMP() function, when I explicit define the format: select
Hi Tom,check issue:
https://www.exasol.com/support/browse/EXASOL-2608.The 'T' is supported
from Exasol version 7 on.I am working on version 7.0.3, it works that
way for me, adding the T to the format string: SELECT
Ok. As we read many fields from large json structures in multi million
record tables, we try to avoid the subquery construction on
json_extract.Otherwise our TMP_DB_RAM tends to 💣 .Currently we use
json_extract for most of the keys and a separate js...
Good morning Lennart,thanks for your response, we are allready using the
new json functions heavily, great stuff 😀 !We built a first prototype
for creating a flat key/value pair json, please see the code below. We
did not manage so far, to pass the ...