Change date format to DAY, MMM dd, yyyy

Help Activities
,
1

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.

2

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

3

@Ashwini_Patil

Check below for your reference

Hope this may help you

Thanks