Re: **Updating Time part**

From: <chandrasekar_at_my-dejanews.com>
Date: Wed, 20 Jan 1999 12:49:27 GMT
Message-ID: <784jcl$3cf$1_at_nnrp1.dejanews.com>


[Quoted] [Quoted] 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.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 13:49:27 CET

Original text of this message