Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
date range in sql query is ignored (Read 787 times)
MikeLust
YaBB Newbies
*


I Love SQL*XL

Posts: 1
date range in sql query is ignored
13.05.16 at 19:15:20
 
In a search of other forums there doesn't seem to be a report of this finding with SQL*XL 515.  The date range in my sql query is being ignored and the query pulls into Excel all records in the Oracle database table being queried (from Kronos Visionware), regardless of the date in the date field.  The same query returns an appropriate resultset when run the Visionware user interface custom query section. This is a recent occurrence - any advice?  Thanks.
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: date range in sql query is ignored
Reply #1 - 25.05.16 at 09:02:31
 
Hi,
We need a little more information. Which database do you use and which driver?
 
In general it is best to be explicit with dates and not rely on implicit conversions. A good query would be:
 
select * from mytable where mydate between to_date('01-01-2000', 'dd-mm-yyyy') and to_date('01-01-2010', 'dd-mm-yyyy');
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1