MySQL

1. Date, Datetime, Time, Timestamp 타입 구조 범위 예시 Date YYYY-MM-DD 1000-01-01 9999-12-31 2023-12-29 Datetime YYYY-MM-DD HH:MM:SS 1000-01-01 00:00:00 9999-12-34 23:59:59 2023-12-29 12:28:47 Time HH:MM:SS -838:59:59 838:59:59 12:28:47 Timestamp YYYY-MM-MM HH:MM:SS 1970-01-01 00:00:01 2038-01-19 03:14:07 UTC 2023-12-29 12:28:47 2. Datetime vs Timestamp Datetime Timestamp 타입 문자형 숫자형 용량 8byte 4byte 입력 값 ..