使用数据处理函数

1）文本处理函数Upper()
SELECT vendname,Upper(vendname) AS vendnameupcase
FROM vendors
ORDER BY vend_name;

2)日期和时间处理函数

SELECT custid,ordernum
FROM orders
WHERE order_date=‘2005-09-01’;

SELECT custid,ordernum
FROM orders
WHERE Date(order_date)=‘2005-09-01’;

检索出2005年9月下的所有订单
法1:
SELECT custid,ordernum
FROM orders
WHERE Date(order_date) BETWEEN ‘2005-09-01’ AND ‘2005-09-30’;

法2:
SELECT custid,ordernum
FROM orders
WHERE Year(orderdate)=2005 AND Month(orderdate)=9;

3)数值处理函数