Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - Update time
Azman,
Use the following function ; to_date('04-MAR-98 01:03:00','DD-MON-YY HH24:MI:SS) in your update statement.
Bhanu-
azhan98_at_tm.net.my wrote:
> 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 - 22:44:11 CST