Date format is throwing error as ORA-01843: not a valid month while using execute query activity

Help Activities
, , ,
1

I need to get a table from database where (date_column_name)<Today.

The format of the value in the column date_column_name is dd-MM-yy but while the sql query is given as
“Select * From Work Where inputdate<‘19-08-22’;”
The error is thrown as ORA-01843: not a valid month

2

Hey @Athulya_S_Chandran,

First you need to correct your select query like the below query and then try
SELECT * FROM Customers WHERE Country=‘India’;

Thanks,
Sanjit

3

@Sanjit_Pal ,

Thank you…I have edited the query by adding FROM and my requirement is to filter using date and not country.

4

Hey @Athulya_S_Chandran,

Try using this query.
SELECT * FROM Customer WHERE CreationDate BETWEEN ‘19-08-2022 00:00:00’ AND ‘19-08-2022 23:59:59’;

Replace Customer with your actual table name and
Replace CreationDate with your actual datatime column name

Thanks,
Sanjit

5

Standard date formatting is MM-dd-yyyy so you’re telling it the month is 19.