SQLite Forum

Query data between dates
Login
Chronological Hierarchical 
Hello, 

Im try make this query, bettween dates, and my select no return rows.

<code>
select
	*
from
	Apontamento v
where
	(v.DataInicio BETWEEN 'Wed Feb 03 2021 23:00:00 GMT-0300 (Brasilia Standard Time)' AND 'Thu Feb 04 2021 07:20:00 GMT-0300 (Brasilia Standard Time)')
<code>

2 lines between dates, exist in my database;

|id|OrdemServicoId|OrdemServicoItemId|ItemOS|NegocioId|Matricula|MotivoParadaId|DataInicio|DataFim|UsuarioId|
|--|--------------|------------------|------|---------|---------|--------------|----------|-------|---------|
|390035272||||1|26704|14|Wed Feb 03 2021 23:00:00 GMT-0300 (Brasilia Standard Time)|Wed Feb 03 2021 23:58:38 GMT-0300 (Brasilia Standard Time)|JOSE-SPIGOLON|
|974821305||||1|26704|81|Wed Feb 03 2021 23:58:38 GMT-0300 (Brasilia Standard Time)||JOSE-SPIGOLON|

How to make this query correctly ?