Re: **Updating Time part**
Date: Wed, 20 Jan 1999 14:22:35 -0800
Message-ID: <36A6572B.75FB_at_nospam.btinternet.com>
chandrasekar_at_my-dejanews.com wrote:
>
> Hi abhijit, I 've been trying to find a solution for your problem . Once if
> I find the solution, I'll let u know . I request you to do the same . Thankx
> & cheers G.CHANDRASEKAR
>
> In article <77vi4p$o7k$1_at_nnrp1.dejanews.com>,
> abhijitde_at_my-dejanews.com wrote:
> > Hi friends,
> >
> > I have a table containing two fields,
> >
> > adate date
> > atime varchar2(8)
> >
> > Sample data:-
> >
> > adate atime
> > 10-Jan-1999 12:00:00 10:30:50
> > 10-Jan-1999 12:00:00 13:30:10
> > 12-Jan-1999 12:00:00 09:30:00
> >
> > Could anyone let me the syntax for updating time part of field adate
> > with atime?
> >
> > Thanks in advance.
> >
> > Abhijit.
UPDATE table
[Quoted] SET adate = TO_DATE(TO_CHAR(adate, 'DD-MON-YYYY')||a_time)
WHERE .....;
Rick
Received on Wed Jan 20 1999 - 23:22:35 CET