'Change timestamp format in oracle

I am getting timestamp format as '01-APR-21 12.02.00.496677000 AM' from oracle, I want to change the format to load data into sql server column with datatype as datetime.

Current Input: '01-APR-21 12.02.00.496677000 AM' Expected Output : 2021-04-01 12:02:00.496

I need to write the code in oracle to change timestamp format

Thanks Neha



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source