SQL - Updating time, HOW?

From: <azhan98_at_tm.net.my>
Date: Tue, 10 Nov 1998 04:00:35 GMT
Message-ID: <728dp4$ha7$1_at_nnrp1.dejanews.com>

[Quoted] I have insert a data into a table with a field datatype of DATE.

SQL> INSERT INTO MYTIME(MASA)
  2 VALUES('04-MAR-99')
  3 ;

When I select the data using TO_CHAR, I can see the time for that rows.

SQL> SELECT TO_CHAR(MASA,'DD-MON-YY HH:MI:SS') FROM MYTIME; TO_CHAR(MASA,'DD-MON-YYHH:MI:SS')

---

01-MAR-99 12:00:00
02-MAR-99 12:00:00
04-MAR-99 12:00:00

However, I have a problem in updating the row value for both date and time. What SQL update command should I type if I want to update the time for 04-MAR-99 from 04-MAR-99 12:00:00 to become 04-MAR-99 01:03:00

Thanks for your help.

Azman

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 05:00:35 CET