Re: ORA-01861 Literal Does Not Match Format String

Sybrand Bakker wrote:
> On 3 Aug 2006 13:12:55 -0700, virgilbvm1_at_yahoo.com wrote:
>
> You would better use the add_month function like this
>
> <= add_month(to_date('2006-07-01 00:00:00','yyyy-mm-dd
> hh24:mi:ss'),1)-(1/3600)
> which means August 1, min one second.

Sybrand -

Do you have a special reason why you use "<= add_month(..)-one_second" instead of "< add_month(..)" ?

best,
Martin Received on Fri Aug 04 2006 - 19:09:22 CDT