SQLite Text to Date not working

[ubkra]

I'm downloading a JSON file and saving it into my SQLite DB. There's a date field in the JSON, 2021-11-25 for example.

Geting JSON data into List of.

Dim personList = JsonSerializer.Deserialize(Of List(Of Classes.Person))(jsonResponse, serializerOptions)

Inserting into my DB and once inside as the correct format in a text colum

For Each p As Person In PersonList
    con.Execute("INSERT OR REPLACE INTO Persons(personId, dob) VALUES (@personId, @Dob)", p)
Next

When i come to pull the data from the database, I get just the year 2024, 2018 whatever but not the month or day. Why?

    listBox1.Enabled = False
    Dim output = con.Query(Of Person)("SELECT * FROM Person", New DynamicParameters())
    listBox1.DataSource = output.ToList()
    listBox1.DisplayMember = "personId"
    listBox1.Enabled = True

Person Class

Public Class Person
    Public Property personId As Integer
    Public Property Dob As String
End Class

[ubkra]

Data in MySQL is showing as 1982-05-21 as one example.

[kareninstructor]

Rather than a text column, use a DateTime column.

If the time part is not needed, use a DateOnly by converting from DateTime using DateOnly.FromDateTime

[ubkra]

DateTime is not a valid column on SQLite otherwise I would have

[paulg4ije]

If you are putting a string into the database you should (obviously) get the same string out. Have you checked what is actually going into the database using something like SQLiteStudio? I store dates in SQLite in ISO-8601 format and convert to DateTime objects in vb.net.

[wes4dbt]

DateTime is not a valid column on SQLite otherwise I would have

SQLite has a Date data type. Try that.

Edit:

Wait a second. Here you say your using SQLite

I'm downloading a JSON file and saving it into my SQLite DB

And here you reference MySql

Data in MySQL is showing as 1982-05-21 as one example.

Why??

Also, need to see the code for displaying "dob".

[Zvoni]

It's called debugging.
Start with your deserialized data.
Does the full date even arrive in your "PersonList"?

[kareninstructor]

DateTime is not a valid column on SQLite otherwise I would have

It is a valid type.

[Zvoni]

It is a valid type.

Karen, have to disagree.
https://www.sqlite.org/lang_datefunc.html

SQLite does not have a dedicated date/time datatype. Instead, date and time values can stored as any of the following:

ISO-8601	A text string that is one of the ISO 8601 date/time values shown in items 1 through 10 below. Example: '2025-05-29 14:16:00'
Julian day number	The number of days including fractional days since -4713-11-24 12:00:00 Example: 2460825.09444444
Unix timestamp	The number of seconds including fractional seconds since 1970-01-01 00:00:00 Example: 1748528160

Though you CAN use Datatypes like Date, DateTime (and others you're used to from other DBMS) during creation of a Table (via SQL CREATE TABLE blablabla), and SQLite will even save it in its Metadata.
Internally, SQLite will use its own storage class with the closest Affinity
https://www.sqlite.org/datatype3.html

[kareninstructor]

All that matters is a developer can work with dates no matter the Metadata.