**Updating Time part**

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 - 08:56:36 CST