AnsweredAssumed Answered

SQL Querying Date Field using = ?

Question asked by user28311 on Sep 1, 2018
Latest reply on Sep 2, 2018 by user19752

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 !

Outcomes