month1 [SQL 기초] 날짜형식 연/월/일 2025.02.24 - [프로그래밍/SQL, Hive, SAS 관련 정보] - [SQL] Table of Contents날짜요소 추출(1) 공통방법: Extract함수를 활용하면 됩니다. SELECT EXTRACT(YEAR FROM date_column) AS year, EXTRACT(MONTH FROM date_column) AS month, EXTRACT(DAY FROM date_column) AS dayFROM your_table;(SELECT title AS resultsFROM MovieRating JOIN Movies USING(movie_id)WHERE EXTRACT(YEAR_MONTH FROM created_at) = 202002GROUP BY titleORDER BY AVG(rat.. 2025. 2. 26. 이전 1 다음 반응형