**Updating Time part**

From: <abhijitde_at_my-dejanews.com>
Date: Mon, 18 Jan 1999 14:57:34 GMT
Message-ID: <77vi4p$o7k$1_at_nnrp1.dejanews.com>



[Quoted] 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 Received on Mon Jan 18 1999 - 15:57:34 CET

Original text of this message