sql query: to_date() :ORA-01830: date format picture ends before

2003-03-11 Thread Basavaraja, Ravindra
Hi... I am getting the following error with a query like this select * from cust where to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = to_date('01-FEB-03 07:53:28','DD-MON-YY HH24:MI:SS') ORA-01830: date format picture ends before converting entire input string What is the problem? Thanks --

Re: sql query: to_date() :ORA-01830: date format picture ends before

2003-03-11 Thread Stephane Faroult
Basavaraja, Ravindra wrote: Hi... I am getting the following error with a query like this select * from cust where to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = to_date('01-FEB-03 07:53:28','DD-MON-YY HH24:MI:SS') ORA-01830: date format picture ends before converting entire input

Re: sql query: to_date() :ORA-01830: date format picture ends before

2003-03-11 Thread Igor Neyman
Why are trying to compare date to string: to_char(...) = to_date(...) ? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:20 PM Hi... I am getting the following error with a

Re: sql query: to_date() :ORA-01830: date format picture ends before

2003-03-11 Thread Sergey V Dolgov
Hello Ravindra, You should use to_char OR to_data not both. select * from cust where to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = '01-FEB-03 07:53:28' Wednesday, March 12, 2003, 2:20:17 AM, you wrote: BR Hi... BR I am getting the following error with a query like this BR select * from cust