Minus days from sysdate : SYSDATE « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. SYSDATE

Minus days from sysdate

 
SQL>
SQL> CREATE TABLE purchase (
  2       product_name  VARCHAR2(25),
  3       salesperson   VARCHAR2(3),
  4       purchase_date DATE,
  5       quantity      NUMBER(4,2));

Table created.

SQL>
SQL> INSERT INTO purchase VALUES ('Small Widget', 10, sysdate, '1);
ERROR:
ORA-01756: quoted string not properly terminated


SQL> INSERT INTO purchase VALUES ('Medium Widget', 15, sysdate-14, 2);

1 row created.

SQL> INSERT INTO purchase VALUES ('Round Station', 25, sysdate-7, 3);

1 row created.

SQL> INSERT INTO purchase VALUES ('Product Number', 10, sysdate+7, 4);

1 row created.

SQL>
SQL>
SQL>
SQL> DROP TABLE purchase;

Table dropped.

SQL>
SQL>

 

Related examples in the same category