support for TRY_CONVERT or TRY_CAST functions
Azure SQL DW does not support try_convert or try_cast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.
Thanks for your suggestion. We are looking into this scenario for a future release. 10697302