CODEWITHSUNDEEP
sqloracle-database
stighy
stighy

Reputation: 7170

Error in this query : how to solve it ?

I've a Oracle query like this: 

 SELECT * FROM 
    WHERE 
        CODE='AMB01'
        AND MyHour BETWEEN 
            TO_DATE('11/01/2018 16:00:00', 'DD/MM/YYYY hh24:mi:ss') AND
            TO_DATE('11/01/2018 16:30:00', 'DD/MM/YYYY hh24:mi:ss')

It return an error : 

Month not valid

Myhour is a String field.

What can be the error ?

Thanks

Upvotes: 0

Views: 76

Answers (2)

Warf
Warf

Reputation: 311

Edited: You need to convert MyHour, not between part.

SELECT * FROM 
    WHERE 
        CODE='AMB01'
        AND TO_DATE(MyHour, 'DD/MM/YYYY hh24:mi:ss') BETWEEN 
           '11-01-2018 16:00:00' AND
           '11-01-2018 16:30:00'

Upvotes: 1

Hüseyin Burak Karadag
Hüseyin Burak Karadag

Reputation: 1888

if MyHour type is different , Set column type as Date 

UPDATE_DATETIME           DATE

 SELECT * FROM YourTable
    WHERE   MyHour BETWEEN 
  TO_DATE('11/01/2018 16:00:00', 'DD/MM/YYYY hh24:mi:ss') AND
  TO_DATE('11/01/2018 16:30:00', 'DD/MM/YYYY hh24:mi:ss')

Upvotes: 0

Related Questions