Re: **Updating Time part**

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Mon, 18 Jan 1999 16:21:42 GMT
Message-ID: <36a55e07.8909991@inet16.us.oracle.com>

On Mon, 18 Jan 1999 14:56:36 GMT, 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?
>

update T
set adate =
to_date(to_char(adate,'DD-MON-YYYY' )||' '||atime, 'DD-MON-YYYY HH24:MI:SS')

eg.

SQL> insert into t values

    ( to_date( '10-Jan-1999', 'DD-Mon-yyyy' ), '10:30:50' ); 1 row created.

SQL> select to_char( adate, 'DD-MON-YYYY HH24:mi:ss' ), atime from t;

TO_CHAR(ADATE,'DD-MO ATIME

-------------------- --------

10-JAN-1999 00:00:00 10:30:50 SQL> update T
  2 set adate =
  3 to_date(to_char(adate,'DD-MON-YYYY' )||' '||atime, 'DD-MON-YYYY HH24:MI:SS');
1 row updated.

SQL> select to_char( adate, 'DD-MON-YYYY HH24:mi:ss' ), atime from t;

TO_CHAR(ADATE,'DD-MO ATIME

-------------------- --------

10-JAN-1999 10:30:50 10:30:50 Hope this helps.

chris.

>Thanks in advance.
>
>Abhijit
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jan 18 1999 - 10:21:42 CST