Use TO_DATE('December 31, 2002, 11:30 P.M.','Month dd, YYYY, HH:MI P.M.') in set statement

  
SQL>
SQL> CREATE TABLE product (
  2       product_name     VARCHAR2(25),
  3       product_price    NUMBER(4,2),
  4       quantity_on_hand NUMBER(5,0),
  5       last_stock_date  DATE);

Table created.

SQL>
SQL> INSERT INTO product VALUES ('Small Widget', 99, 1, '15-JAN-03');

1 row created.

SQL> INSERT INTO product VALUES ('Medium Widget', 75, 1000, '15-JAN-02');

1 row created.

SQL> INSERT INTO product VALUES ('Product Number', 50, 100, '15-JAN-03');

1 row created.

SQL> INSERT INTO product VALUES ('Round Church Station', 25, 10000, null);
                                  
1 row created.

SQL>
SQL>
SQL> UPDATE product
  2  SET    last_stock_date = TO_DATE('December 31, 2002, 11:30 P.M.',
  3                                   'Month dd, YYYY, HH:MI P.M.')
  4  WHERE  product_name LIKE '%Zinc%';

0 rows updated.

SQL>
SQL>
SQL>
SQL> DROP TABLE product;

Table dropped.

SQL>
SQL>
SQL>

Related examples in the same category

1.	You can update a column and set it back to the default using the DEFAULT keyword in an UPDATE statement
2.	Use arithmetic operators and functions in the SET clause to modify data
3.	An example of using a function in the SET clause
4.	Change multiple rows and multiple columns in the same UPDATE statement
5.	Update data from existing column
6.	Update four columns
7.	Update number type column
8.	Update one row

Use TO_DATE('December 31, 2002, 11:30 P.M.','Month dd, YYYY, HH:MI P.M.') in set statement : UPDATE Set Clause « Insert Delete Update « Oracle PL / SQL

Related examples in the same category