--WORD
鏍煎紡
--
鍙紪杈?/p>
--
閫夋嫨棰橈紙閽堝浠ヤ笅棰樼洰锛岃閫夋嫨鏈�绗﹀悎棰樼洰瑕佹眰鐨勭瓟妗堛�傞拡
瀵规瘡涓�閬撻鐩紝鎵�鏈夌瓟妗堥兘閫夊锛屽垯璇ラ寰楀垎锛屾墍閫夌瓟妗堥敊
璇垨涓嶈兘閫夊嚭鎵�鏈夌瓟妗堬紝鍒欒棰樹笉寰楀垎銆?/p>
1-50
棰橈紝姣忛
2
鍒嗭級
1
锛?/p>
鍦?/p>
Oracle
涓紝鍋囪闇�瑕佷粠瀛﹀憳琛紙
student
锛変腑鏌ヨ
瀛﹀憳鐨勬瘯涓氭椂闂达紙
graduatetime
锛夊苟鎸夌収骞?/p>
/
鏈?/p>
/
鏃?/p>
鐨勬牸寮忚緭鍑猴紝鍒欎互涓?/p>
SQL
璇彞姝ｇ‘鐨勬槸锛堬級
銆?/p>
(
閫夋嫨涓�
椤?/p>
)
a)
SELECT
EXTRACT(Y
FROM
s.graduatetime)||'/'||
EXTRACT(M
FROM
s.graduatetime)||'/'||
EXTRACT(D
FROM
s.graduatetime)
FROM
students;
b)
SELECT
EXTRACT(YEAR
s.graduatetime)||'/'||
EXTRACT(MONTH
s.graduatetime)||'/'||
EXTRACT(DAY
s.graduatetime)
FROM
students;
c)
SELECTEXTRACT(YEAR
FROM
s.graduatetime)||'/'||
EXTRACT(MONTH
FROM
s.graduatetime)||'/'||
EXTRACT(DAY
FROM s.graduatetime)
FROM
students;