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