Re: SQL - Updating Time : How???

From: david <david_at_elpunt.com>
Date: Tue, 10 Nov 1998 12:08:07 +0100
Message-ID: <7296gm$5lp$1@diana.bcn.ibernet.es>

The update clause you must use, if I've understood your problem, is the following...

SQL> update prova set a=to_date('1-1-1998 01:04:00','dd-mm-yyyy hh:mi:ss')   2 where a=to_date('1-1-1998','dd-mm-yyyy');

1 fila actualitzada.

SQL> select TO_CHAR(a,'DD-MON-YY HH:MI:SS') FROM prova;

TO_CHAR(A,'DD-MON-YYHH:MI:SS')

---

01-GEN-98 01:03:00
01-GEN-98 01:04:00 SQL> See you!

David Bosch Geli Received on Tue Nov 10 1998 - 05:08:07 CST