Strange behaviour when filtering by date in Oracle -

-

i'm on oracle database, following query:

select codi_belf, data_elab,id_inte,anno mimsspam_tab id_inte = 504;

retrieves 6 records 

 e924    05-ago-15   504 2015 d458    05-ago-15   504 2015 d458    05-ago-15   504 2015 b275    05-ago-15   504 2015 e924    05-ago-15   504 2015 b275    05-ago-15   504 2015

where "data_elab" field of type date , ago italian locale aug.

i try filter date this: 

select codi_belf, data_elab,id_inte,anno  mimsspam_tab id_inte = 504  , data_elab = to_date('05/08/2015','dd/mm/yyyy');

and no results..

moreover if filter way:

select codi_belf, data_elab,id_inte,anno   mimsspam_tab id_inte = 504  , to_char(data_elab,'dd/mm/yyyy')='05/08/2015';

i got 6 records back!

shouldn't 2 ways of filtering equivalent? why aren't? , why first eats 6 records? depend on weird configuration of oracle installation i'm querying to?

what see in first query database default date format, determined nls parameters. date field contains time information, don't see it.

in second query, when use to_date(), convert string date , don't provide time information, 00:00:00 time part of date. comparing field (which includes time information) result in no match.

in third query, when use to_char(), convert date field string doesn't include time information. comparing literal string, matched records.

try think of date field binary information, not character string. try not rely on database default parameters.


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more