Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
When I do a query by a date range I don't get any records? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-26 12:02:32 |
Make sure the query is using the correct date format for SQL as follows:
select * from small where date < {d '2006-05-27'}
Also make sure that in the ODBC section of the control panel of Windows that the settings for 2 or 4 digit years is correct. Selections on dates will only work if this setting is correct.
Note: According to ODBC rules, NULL dates (where no date has been entered) are not included in queries where a specific date comparison is requested. In the above example, dates less than the date requested will be shown, but records without a date entry (null dates) will not be included, unlike DataFlex operation. You can select these records specifically by modifying the query to:
select * from small where date < {d '1996-05-27'} or date IS NULL |
|
|
|
|