1. dayname(컬럼 or "날짜값")을 넣으면 날짜가 요일형식으로 나온다.
SELECT DATE(event_timestamp_kst) AS dt,
DAYNAME(event_timestamp_kst) AS dayname,
COUNT(DISTINCT user_pseudo_id, ga_session_id) AS sessions
FROM ga
WHERE event_timestamp_kst BETWEEN "2022-01-22 00:00:00" AND "2022-01-28 23:59:59"
GROUP BY dt, dayname
ORDER BY dt
2. DATE_FORMAT(칼럼 or 날짜, "형식")
날짜를 원하는 형식으로 바꿔준다.
ex) DATE_FORMAT(last_order_date, '%Y-%m-01') 로 쓴다.
3. DATE와 DAY
SELECT MIN(order_purchase_timestamp) AS first_order_date,
MAX(order_purchase_timestamp) AS last_order_date
FROM olist_orders_dataset
SELECT DATE(MIN(order_purchase_timestamp)) AS first_order_date,
DAY(MAX(order_purchase_timestamp)) AS last_order_date
FROM olist_orders_dataset
정규표현식 (0) | 2022.08.12 |
---|---|
서브쿼리 (0) | 2022.08.01 |
집계함수, GROUP BY, HAVING (0) | 2022.07.26 |
WHERE, ORDER BY (1) | 2022.07.26 |
MySQL 이론2 (0) | 2022.07.18 |
댓글 영역