**Updating time part**

From: <abhijitde_at_my-dejanews.com>
Date: Mon, 18 Jan 1999 14:55:53 GMT
Message-ID: <77vi1k$o6m$1@nnrp1.dejanews.com>

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.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 18 1999 - 08:55:53 CST