Re: **Updating Time part**--Thanx!

From: <abhijitde_at_my-dejanews.com>
Date: Fri, 22 Jan 1999 18:34:15 GMT
Message-ID: <78agb6$992$1_at_nnrp1.dejanews.com>


Hi Jonathan, Thanks for the solution. The first solution works perfectly after u make its as HH24 in the format mask.

Abhijit.

In article <36a73a3c.0_at_145.227.194.253>,   "Jonathan Samuel" <j.w.samuel_at_cfm1220.x400.icl.co.uk> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 19:34:15 CET

Original text of this message