Oracle Sql Help

[madhub8]

please help this

 

SELECT * FROM X_TBL

WHERE DATE< TO_DATE('09-01-2015', 'MM-DD-YYYY');

 

deentlo emaina error/mitake unda?

Oracle lo...

[ajay1920]

please help this

 

SELECT * FROM X_TBL

WHERE DATE< TO_DATE('09-01-2015', 'MM-DD-YYYY');

 

deentlo emaina error/mitake unda?

Oracle lo...

 

 

Its correct if you are using in Oracle..

[cool_dood]

error bol bhai, apudu seppocchu issue enti anedi

[vikuba]

DATE antey field X_TBL lo undhaa check chei

[Comfort]

try using this:

 

 

SELECT * FROM X_TBL

WHERE DATE< sysdate -25;

[raaj]

looks good....

 

DATE ane field undo ledo check chey table lo....

 

Also error ento teliste apudu inka easy ga chepochu issue enti anedi

[Walcommon]

please help this

 

SELECT * FROM X_TBL

WHERE DATE< TO_DATE('09-01-2015', 'MM-DD-YYYY');

 

deentlo emaina error/mitake unda?

Oracle lo...

 

Query looks perfect!! 

check DATE column in where condition is there or not.

And let us know if you have error.