Hi experts,
We're using Database 12.2 and I'd like to know if there's an specific mask for the timezone when we process a string like this (timezone=GMT):
"2021-06-10T09:15:42.000+0000"
I've progressed till this:
SELECT to_timestamp('2021-06-10T09:15:42.000', 'YYYY-mm-dd"T"hh24:mi:ss.ff3')
FROM dual;
But I'd like to know how to include the timezone +0000 section.
PS: This is just for learning, I know I could easily make a substring and split the string and process the timezone some other way, but I'd like to know if Oracle has an specific mask for this.
Regards,
Jose.