I have a to tables, and the field **`_fecha`** is a **TEXT** type colunm, and i consulted several examples and nothing.

```
SELECT mae_movintos._id
      , mae_movintos._fecha
      , mae_movintos._tipo
      , mae_movintos._origen
      , mae_movintos._destino
      , mae_movintos._category
      , mae_movintos._monto
      , mae_movintos._orden
   FROM mae_movintos, mae_cuentas
  WHERE mae_cuentas._id = mae_movintos._id
    AND strftime('%s',mae_movintos._fecha) = strftime('%s','2016-10-10')

```