Re: SQL update statement and TIMESTAMP
From: Robert Dimitrovski <robert.dimitrovski_at_ht.hr>
Date: Tue, 13 May 2003 08:45:44 +0200
Message-ID: <1052808423.850802_at_tuxri2.tkcrij.ht.hr>
Date: Tue, 13 May 2003 08:45:44 +0200
Message-ID: <1052808423.850802_at_tuxri2.tkcrij.ht.hr>
Try to use a conversion function to_date()
"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?
>
>
Received on Tue May 13 2003 - 08:45:44 CEST