salida.txt

MariaDB [ventas]> select * from ventas where fecha >= '2019-11-06 00:00:00' and fecha < '2019-11-07 00:00:00';
+----+------------+---------------------+--------+-------+-----------+--------+
| id | idPaciente | fecha               | total  | vista | idUsuario | estado |
+----+------------+---------------------+--------+-------+-----------+--------+
| 15 |         12 | 2019-11-06 18:30:35 | 450.00 |     0 |         2 |      2 |
| 16 |          9 | 2019-11-06 19:05:39 | 750.00 |     0 |         2 |      2 |
| 17 |          1 | 2019-11-06 19:09:54 | 900.00 |     0 |         2 |      2 |
+----+------------+---------------------+--------+-------+-----------+--------+
3 rows in set (0.00 sec)