Re: SQL update statement and TIMESTAMP

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 13 May 2003 00:26:56 -0700
Message-ID: <a20d28ee.0305122326.f77a21c_at_posting.google.com>

"Pierre Tremblay" <pierret_at_pierretci.com> wrote in message news:<5KTva.898$I83.237858_at_news20.bellglobal.com>...
> Hi
>
> Simple question.
>
> When issuing an UPDATE Table SET MyDateTimeCol = '4 Apr 98 01:00:00',
> Oracle doesnt seem to like that and it is complaining. Does the statement
> need absolutely a cast or conversion function?

unless you issue
alter session set nls_date_format appropiately yes. In fact, you should NEVER rely on a default date format!! The extra typing is apparently too much for you, but regrettably unavoidable if you want a stable system.

Sybrand Bakker
Senior Oracle DBA Received on Tue May 13 2003 - 09:26:56 CEST

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Blob versus Server Directory"
Previous message: Christophe: "Enumerate columns and table in a request"
In reply to: Pierre Tremblay: "SQL update statement and TIMESTAMP"
In reply to Pierre Tremblay: "SQL update statement and TIMESTAMP"
Next in thread: Sybrand Bakker: "Re: Blob versus Server Directory"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message