After a lot of R&D still not able to convert date in dd-Mon-YYYY format .am uisng open query from SSMS to oracle view but not able convert the date So reuesting you please help.
below are my query select * from openquery(oracle,'select to_char(to_date("created date",''yyyy-mm-dd''),''dd-mon-yyyy'') from Oracle View')
Data is coming the the view in below format for date 2020-10-07 00:00:000