Datetime conversion issue from Linq

Question

I've included some code from my application that uses Linq to retrieve data from a database.

As previously stated, the code stores data in the var variable. This var variable holds a datetime value. However, while using the following code, the following error occurs. Code : DateTime LastNotificationDate = DateTime.Parse(LastNotificationRecord.Value); Error : String was not recognized as a valid In database data stored as : 4/22/2023 11:00:00 AM NB: Not able to change dateformat in database. How i overcome this issue

Answer 1

In case of strings, check an example:

DateTime LastNotificationDate = DateTime.Parse( "4/22/2023 11:00:00 AM", CultureInfo.InvariantCulture );

However, the values should be stored using date and time types (datetime or datetime2, for example). LastNotificationRecord.Value should be a DateTime. Parsing should be avoided.