Re: Eror: ORA-01861 Literal Does Not Match Format String

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

> select * from my_table where pd_date < '1999-04-13
> 22:18:05';

Try:
where pd_date < to_date ('1999-04-13 22:18:05', 'yyyy-mm-dd hh: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.