閫夋嫨棰橈紙閽堝浠ヤ笅棰樼洰锛岃閫夋嫨鏈�绗﹀悎棰樼洰瑕佹眰鐨勭瓟妗堛�傞拡瀵规瘡涓�閬撻鐩紝鎵�鏈?/p>
绛旀閮介�夊锛屽垯璇ラ寰楀垎锛屾墍閫夌瓟妗堥敊璇垨涓嶈兘閫夊嚭鎵�鏈夌瓟妗堬紝鍒欒棰樹笉寰楀垎銆?/p>
1-50
棰橈紝姣忛
2
鍒?/p>
锛?/p>
1
锛?/p>
鍦?/p>
Oracle
涓?/p>
锛?/p>
鍋?/p>
璁?/p>
闇�
瑕?/p>
浠?/p>
瀛?/p>
鍛?/p>
琛?/p>
锛?/p>
student
锛?/p>
涓?/p>
鏌?/p>
璇?/p>
瀛?/p>
鍛?/p>
鐨?/p>
姣?/p>
涓?/p>
鏃?/p>
闂?/p>
锛?/p>
graduatetime
锛夊苟鎸夌収骞?/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;