Load datetime to sql data reader


#1

Hi,

I have some Table in SQLCipher database with 14 columns. Two of them is DateTime type. When I am trying to get data to reader I get the error: String was not recognized as a valid DateTime.

How to do it properly to avoid such a error.

Thank you.

Martin


#2

Hello @Martin

Could you share some additional details about the situation you are investigating? What is the schema for the table you are referring to? What code are you using to read the results? Are you certain the contents of the database contain a date time value in those specific fields? Please feel free to contact us at support@zetetic.net if you would prefer.