Filtering by dates SQLite C #

Question

Filtering by dates SQLite C #

Navigation

#1 by (1 votes)

0

I have a table in SQLite with several fields including a Text type date with the following format:

"2018-11-04 12:13:00"

Since SQLite does not have the Date field in problems to make queries of dates greater or lesser than one that happens with the same format since he takes it as a string, someone could tell me if it is possible to make this type of query ?

c# datetime sqlite

asked by DVertel 04.11.2018 в 18:13

source

1 answer

Change color to the figure does not take it, canvas ReentrantLock .lock

score 1 · Answer 1

You could format the date using something like this

var FechaInicio = fecha.ToString("yyyy-MM-dd");
var FechaFin = fecha.ToString("yyyy-MM-dd");

using(var connection = new SQLiteConnection(cntnStr))
{
    connection.Open();

    string query = "select * from tabla where campoDate >= @FechaInicio and campoDate <= @FechaFin";
    SQLiteCommand cmd = new SQLiteCommand(query, connection);
    cmd.Parameters.Add(new SQLiteParameter("@FechaInicio", FechaInicio));
    cmd.Parameters.Add(new SQLiteParameter("@FechaFin", FechaFin));

    var reader = cmd.ExecuteReader();

    //resto codigo
}

if the format needs the time you could use

var FechaInicio = fecha.ToString("yyyy-MM-dd HH:mm:ss");