Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01861 Literal Does Not Match Format String

Re: ORA-01861 Literal Does Not Match Format String

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 05 Aug 2006 07:39:22 +0200
Message-ID: <3kb8d2d4d81n7ahccqjgc6h5ep7r8o4ghm@4ax.com>


On 4 Aug 2006 17:09:22 -0700, "Martin T." <bilbothebagginsbab5_at_freenet.de> wrote:

>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

I want to make sure I include the entire day, even if there is a time in it. This construction also warns me there *is* a time in it.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Aug 05 2006 - 00:39:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US