I have a SQLite DB that was created with my VB.net APP. One of the tables has a field to hold a date. Originally I was using datetime or something like that for the data type but was having issues so I changed it to VARCHAR(25) trying to get things to work.

I pull the system date and time and write to that field. All works well.

When I try to pull the date and time from that field and do something with it I get an error.

When I look at the debugger it has the value for the date but it does not have any spaces in it, “8/19/20241:48:41PM” If I use DB Browser for SQLite it has the string of text in the field as “8/19/2024 1:48:41 PM”

Anyone ever experienced this before?