SQL update statement and TIMESTAMP

From: Pierre Tremblay <pierret_at_pierretci.com>
Date: Mon, 12 May 2003 16:51:09 -0400
Message-ID: <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? Received on Mon May 12 2003 - 22:51:09 CEST

This message: [ Message body ]
Next message: Vaughan Mc Carthy: "ORA-06502: PL/SQL: numeric or value error: character to number conversion error"
Previous message: Michael Hill: "Blob versus Server Directory"
Next in thread: Pierre Tremblay: "Re: SQL update statement and TIMESTAMP"
Reply: Robert Dimitrovski: "Re: SQL update statement and TIMESTAMP"
Reply: Sybrand Bakker: "Re: SQL update statement and TIMESTAMP"
Reply: Jim Kennedy: "Re: SQL update statement and TIMESTAMP"
Reply: Pierre Tremblay: "Re: SQL update statement and TIMESTAMP"

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

Original text of this message