não aparece os dados coletor API e formapag urlretorno

[cirinho]

Fazendo a consulta o problema parece estar na hora que vem junto com a data fazendo a consulta com LIKE '2024-09-15%' deve resolver o problema.

MariaDB [mkradius]> SELECT datavenc, datapag, valorpag, coletor, formapag, login  FROM sis_lanc  WHERE AND datapag LIKE '2024-09-15%'  ORDER BY datapag ASC;            ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND datapag LIKE '2024-09-15%'  ORDER BY datapag ASC' at line 1
MariaDB [mkradius]> SELECT datavenc, datapag, valorpag, coletor, formapag, login
    -> FROM sis_lanc
    -> WHERE datapag LIKE '2024-09-15%'
    -> ORDER BY datapag ASC;
+---------------------+---------------------+----------+---------+-------------+--------------------+
| datavenc            | datapag             | valorpag | coletor | formapag    | login              |
+---------------------+---------------------+----------+---------+-------------+--------------------+
| 2024-09-15 00:00:00 | 2024-09-15 00:00:00 | 50.00    | naldo   | PIX         | esteniosnascimento |
| 2024-09-15 00:00:00 | 2024-09-15 06:00:55 | 60       | API     | status.paid | ivanasdeiro        |
| 2024-09-15 00:00:00 | 2024-09-15 06:01:32 | 65       | API     | status.paid | rafaelcoliveira    |
| 2024-09-15 00:00:00 | 2024-09-15 06:04:54 | 50       | API     | status.paid | danielaslsantos    |
| 2024-09-15 00:00:00 | 2024-09-15 06:07:02 | 50       | API     | status.paid | grumap             |
| 2024-09-15 00:00:00 | 2024-09-15 06:07:49 | 60       | API     | status.paid | cristinamngomes    |
| 2024-09-15 00:00:00 | 2024-09-15 06:08:04 | 55       | API     | status.paid | marialaraujo       |
| 2024-09-15 00:00:00 | 2024-09-15 06:08:20 | 60       | API     | status.paid | caiquefasilva      |
+---------------------+---------------------+----------+---------+-------------+--------------------+
8 rows in set (0.01 sec)