ORA-01830: date format picture ends before converting entire input string

Question

The SQL works fine on most installations. However I'm having a problem with an Oracle installation in Canada (possible date localization issue?).

http://www.google.com/search?q=ORA-01830

I'm feeding data to a proprietary processor that generates the SQL. I only provide data. I was hoping for information that may help me solve it without involving support from the processor.

Answer 1

My first attempt will be to try this:

http://www.dba-oracle.com/t_how_to_change_the_default_data_format.htm

Answer 2

Do not rely on implicit date conversions.

Code like:

MY_TABLE.MY_DATE_COLUMN >= '03/07/2008'

is bad practice. Use either:

MY_TABLE.MY_DATE_COLUMN >= to_date('03/07/2008','mm/dd/yyyy')

or

MY_TABLE.MY_DATE_COLUMN >= date '2008-03-07'

Answer 3

I have a problem too, but it's a bit different. INSERT INTO PROJEKTAI (Nr, Pavadinimas, Svarba, Pradzia, Trukme) VALUES (Projektai_Vykdytojai_Nr.NEXTVAL,'Studentu apskaita','Maza','01/01/2005', 12) Error report: SQL Error: ORA-01830: date format picture ends before converting entire input string