Can anyone shed light on my SQL query for date field are problematic doing a simple
Select "name" from mydatabase WHERE date = ? ....
? = "8-27-2018"
I know in SQL databases this will fail if the date field has time component. Do all FM date fields have hidden time components ?
This is the only explanation I can come up with for the issue.
I have to use the work-around which actually works...
Select "name" from mydatabase WHERE date BETWEEN ? AND ?
1. ? = "8-26-2018"
2. ? = "8-28-2018"
maybe I should be querying for
? = "8-27-2018 00:00:00"
Bug or Feature ?
Please vote !