Re: **Updating Time part**
From: Jonathan Samuel <j.w.samuel_at_cfm1220.x400.icl.co.uk>
Date: Thu, 21 Jan 1999 14:37:32 -0000
Message-ID: <36a73a3c.0_at_145.227.194.253>
Date: Thu, 21 Jan 1999 14:37:32 -0000
Message-ID: <36a73a3c.0_at_145.227.194.253>
[Quoted] [Quoted] I am not convinced this syntax is going to work as is.
Has anyone tested it?
I think
SET adate = TO_DATE(TO_CHAR(adate,
'DD-MON-YYYY')||a_time,'DD-MON-YYYYHH:MI:SS)
would be better.
>UPDATE table
> SET adate = TO_DATE(TO_CHAR(adate, 'DD-MON-YYYY')||a_time)
> WHERE .....;
>
>Rick
My alternative suggestion woud be:
UPDATE table
SET adate = adate + to_number(a_time - trunc(a_time)))
WHERE .....;
... assuming a_time is stored as a DATE variable.
Jonathan Received on Thu Jan 21 1999 - 15:37:32 CET