D-49-데이터분석-MySQL

1. 날짜형식

SELECT * FROM table_name WHERE DATE(date_column) = '2024-02-21';

SELECT DATE_FORMAT(some_datetime, '%Y-%m-%d')

2. 특정컬럼을 특정조건으로 값대체

SELECT 
    id,
    CASE 
        WHEN some_date < '2024-01-01' THEN 'Before 2024'
        ELSE some_date
    END AS replaced_date
FROM 
    example;