SQL - Updating Time : How???

From: <azhan98_at_tm.net.my>
Date: Tue, 10 Nov 1998 03:59:47 GMT
Message-ID: <728dnj$h7a$1@nnrp1.dejanews.com>

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 Mon Nov 09 1998 - 21:59:47 CST