MySQL没有DATEPART()函数,但是可以用YEAR()函数来提取年份:
SELECT order-num FROM ORDERS WHERE YEAR(order_date)=2004
Oracle也没有该函数,可用如下:
SELECT order-num FROM ORDERS WHERE to_number(to_char(order_date,'YY'))=2004;
to_char()函数用来提取日期的成分,再用to_number()用来将提取出的转化成数值
MySQL没有DATEPART()函数,但是可以用YEAR()函数来提取年份:
SELECT order-num FROM ORDERS WHERE YEAR(order_date)=2004
Oracle也没有该函数,可用如下:
SELECT order-num FROM ORDERS WHERE to_number(to_char(order_date,'YY'))=2004;
to_char()函数用来提取日期的成分,再用to_number()用来将提取出的转化成数值