Date format for query filter

Why? Why are you not using proper timestamps in your query?

This means that every row in your data table must be converted to see if it matches the startDate. You can't take advantage of the database index on the WORKREQUESTDATE column (if you have created one - which you should if that is the way you will query). Your query will be slow.

1 Like