New Error: ORA-01821: date format not recognized

From: Brian E. Parker <beparker_at_reply.in.the.group.plz>
Date: Wed, 2 May 2001 12:49:12 -0500
Message-ID: <xMXH6.86$c4.10488384@ounews.ou.edu>

This was our latest attempt:

SELECT
    pd_date
FROM
    pson_data
WHERE
    pd_date = to_date('2001-12-01 00:15:00', 'yyyy-mm-dd 24hh:mi:ss' );

And now we are getting this error:

[Oracle][ODBC][Ora]ORA-01821: date format not recognized

I've also tried it without the "24" in the hour spot, but that was wrong. I also tried this:

pd_date = to_date('01-DEC-2001 00:15:00', 'dd-mon-yyyy 24hh:mi:ss' );

and got the above error.

The to_date() is definitely getting us closer, but there is still something wrong. Any more ideas?

TIA,
-BEP "Galen Boyer" <galenboyer_at_yahoo.com> wrote in message news:uvgnjel5k.fsf_at_primix.com...
> Try:
> where pd_date < to_date ('1999-04-13 22:18:05', 'yyyy-mm-dd hh:mi:ss')
Received on Wed May 02 2001 - 12:49:12 CDT