Re: New Error: ORA-01821: date format not recognized

On Wed, 2 May 2001, beparker_at_reply.in.the.group.plz wrote:

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

Try to_date('2001-12-01 00:15:00', 'yyyy-mm-dd hh24:mi:ss' )

-- 
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.