Re: [cx-oracle-users] Query returns zero rows via cx_oracle but some from sql developer

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/3/1 Himanshu <him...@gm...>:
>       WHERE log_date >= '10-Feb-11'
>         AND log_date <= '10-Feb-11'

You should avoid date literals in SQL statements. The exact format may
depend on environment
variables (language...) and other Oracle client settings.
Use something like to_date('10-02-2011', 'DD-MM-YYYY')
Also, this WHERE clause only selects lines where "log_date" has no
time (or midnight).
Is it really the case in your data?

-- 
Amaury Forgeot d'Arc