Re: **Updating Time part**

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

Hi,

update atable set

   adate = to_date (to_char (adate, `DD.MM.YYYY ') || atime, 'DD.MM.YYYY HH24:MI:SS');

This reads out adate, transfers it to_char concatenats it with atime and updates adate with the result.

Regards

Michael Received on Mon Jan 18 1999 - 11:11:45 CST