Thank you Nishant! I am facing issue in converting string to date using CAST function. This syntax throwing error. Appreciate your inputs. CAST(CONCAT('1-','Apr-19') AS DATE)

Thanks Santosh for the quick response!