sql related to date in oracle 10g

I was running this sql in oracle

select * from premium_reg where date_end <= '25/11/2010'

I got an error
Not a valid month

What is the right sql?

 

first you use this
select date_end from premium_reg;

have a careful look at the date format and use accordingly.

Usually oracle uses this date format:
Select* from premium_reg where date_end <= '25-Nov-2010';

 

ok..thank u..

 

There should be some problem in date format even you can try this

select * from premium_reg where date_end <= '11/25/2010'

 

I do not understand very well may explain a little?

 

It is quite normal . By default, Oracle uses mm/dd/yyyy format.

 

select * from premium_reg where date_end list<= '25/11/2010';
mysql_query

 

This is correct. Putting the month first is the US convention. Most of the rest of the world puts the day first. I wonder if there is a way to change the default?