YEAR関数ã?¯å€¤ã?®å¹´ã?®éƒ¨åˆ†ã‚’è¿”ã?—ã?¾ã?™ã€‚引数ã?¯ã€?日付ã€?タイムスタンプã€?ã?Šã‚ˆã?³æ—¥ä»˜ã‚„タイムスタンプを表ã?™æœ‰åйã?ªæ–‡å—列ã?§ã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。 関数ã?®è¿”り値ã?¯1ã?‹ã‚‰9999ã?¾ã?§ã?®é–“ã?®æ•´æ•°ã?§ã?™ã€‚ 引数ã?Œnullã‚’ã?¨ã‚‹äº‹ã?Œã?‚ã‚‹å ´å?ˆã€?返り値ã?¯nullã?¨ã?ªã‚‹ã?“ã?¨ã?Œã?‚りã?¾ã?™ã€‚ ã‚‚ã?—引数ã?Œnullã?ªã‚‰ã€?返り値ã?¯nullã?§ã?™ã€‚
YEAR ( å¼? )
PROJECT表ã?«ã?‚るプãƒã‚¸ã‚§ã‚¯ãƒˆã?‹ã‚‰ã€?é–‹å§‹æ—¥(PRSTDATE)ã?¨å®Œäº†æ—¥(PRENDATE)ã?Œæš¦ã?®ä¸Šã?§å?Œå¹´ã?§ã?‚ã‚‹ã‚‚ã?®ã‚’é?¸æŠžã?—ã?¾ã?™ã€‚
SELECT * FROM PROJECT WHERE YEAR(PRSTDATE) = YEAR(PRENDATE)