Convert Datetime to Date

[Anil_G (Anil Gorthi)]

@ManjunathReddy

So in your db the date format is as you specified with hyphen?ideally just a conversion should be enough

Please check this

DateTime data insert to sql server

Hi @Shyam_Pragash You can use this conversion where you can include time as well Datetime.ParseExact(“yourdatestring”,”MM/dd/yyy hh:mm”,System.Globalization.CulturalInfo.InvariantCulture) MM/dd/yyyy hh:mm - this is the input format so chamge it according to the input you get from excel If you want any specific date format then use .Tostring(“format you need”) like “dd-MM-yy hh:mm” Cheers

Cheers