How can i insert DateTime in SQL?

Question

how can i insert this DateTime in SQL?

1/21/2020 8:30:53.527000 AM +00:00

I know that for 12/12/2020 we can make TO_DATE('12/12/2020', 'DD/MM/YYYY')

Answer 1

In Oracle, in your INSERT statement you can use a TIMESTAMP literal:

TIMESTAMP '2020-01-21 08:30:53.527000 +00:00'

Or use TO_TIMESTAMP_TZ:

TO_TIMESTAMP_TZ(
  '1/21/2020 8:30:53.527000 AM +00:00',
  'MM/DD/YYYY HH12:MI:SS.FF6 AM TZH:TZM'
)