hello experts,
i have been searching oracle documentation for the right timestamp format for the following data below because I would like to only extract YYYY-MM-DD from it to use it for my date filtering in another code but unfortunately, I have been able to find it so far.
Please see sample code below
with t (req_timeinfo) as
(
select '2021-07-21T21:54:38.994+00:00' from dual
union all
select '2021-08-21T21:52:22.643+00:00' from dual
union all
select '2021-04-21T21:20:22.643+00:00' from dual
union all
select '2021-02-21T21:36:22.643+00:00' from dual
)
select * from t