Hi all,
Oracle Database 19c.
I receive date values in the following format: 2021-02-16T15:42:41Z which I want to convert into the database timestamp with timezone column. I don't have practical experience of working with such data types. How can I convert this value into traditional Data or Timestamp or Timestamp with timezone formats for onward insertion into the database?
I tried the TO_CHAR function but no luck.
Any help will be greatly appreciated.
Many Thanks and
Kind Regards,
Bilal