ORA-01830 error trying to pull a date. 1

[bigracefan]

Here is my query:

select * from ecu_prod_detail where
pcb_serial_number = 9000145411 and
step_machine = 10003 and
prod_date_time = to_date('9-7-2001 5:46:16 PM', 'mm/dd/YYYY hh24:mi:ss')

and here is the error message:

ERROR at line 4:
ORA-01830: date format picture ends before converting entire input string


Any idea why I'm getting this error. The date format looks like it'll work on an insert.

Thanks.

Pete

 

[BJCooperIT]

You need:

'mm/dd/YYYY hh:mi:ss pm'

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
^{When posting code, please use TGML to help readability. Thanks!}

 

[jee]

Or lose the PM in your date string (assumes hours are 00-23) and keep hour HH24 format.