Change date format to DAY, MMM dd, yyyy

Hi please help me ! I am using excel to dB and I need to change the column format which is having date as dd/mm/yyyy to DAY, MMM dd, yyyy please help me to write query for this.

You try this

Date.ParseExact(dtStr,"dd/MM/yyyy", New Globalization.CultureInfo("en-IN")).ToString("ddd, MMM, dd, yyyy")

Here dtStr is the date column value of date from source file


Check below for your reference

Hope this may help you