M manuelsalazar Member Licensed User Jan 6, 2020 #1 hi : when I use JRDC2 with timestamp fields to filter a consult, I send 'yyyy-MM-dd hh:mm.ss' to JRDC2 to the JRDC2 command '?', but returns no records found. example : 2019-10-09 00:00:00 we have many records that match ... any ideas ? thanks in advanced. Manuel Salazar Last edited: Jan 7, 2020
hi : when I use JRDC2 with timestamp fields to filter a consult, I send 'yyyy-MM-dd hh:mm.ss' to JRDC2 to the JRDC2 command '?', but returns no records found. example : 2019-10-09 00:00:00 we have many records that match ... any ideas ? thanks in advanced. Manuel Salazar
Erel B4X founder Staff member Licensed User Longtime User Jan 7, 2020 #2 You can use UNIX_TIMESTAMP in the query to convert the string to a timestamp. Upvote 0