field_date.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 16 行

SELECT * FROM plsql101_product
WHERE  last_stock_date = '15-1月-03';

SELECT * FROM plsql101_product
WHERE  last_stock_date = '15-1月-2003';

SELECT * FROM plsql101_product
WHERE  last_stock_date > '31-12月-02';

SELECT * FROM plsql101_product
WHERE  last_stock_date BETWEEN '01-1月-03' and '31-12月-03';

SELECT * FROM plsql101_product
WHERE  last_stock_date NOT BETWEEN '01-1月-03' and '31-12月-03';