사이드바
기술문서:레퍼런스:쿼리:기본:날짜_포맷
문서의 이전 판입니다!
날짜 쿼리
MySQL/MariaDB
SELECT DATE_FORMAT(NOW(), '%Y-%m-%d');
SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s');
SELECT STR_TO_DATE('2025-01-01', '%Y-%m-%d');
SELECT CAST('2025-01-01' AS DATE);
MSSQL
SELECT CONVERT(VARCHAR(10), GETDATE(), 23);
SELECT CONVERT(VARCHAR(19), GETDATE(), 120);
SELECT CONVERT(DATE, '2025-01-01');
SELECT CAST('2025-01-01' AS DATE);
Oracle/Tibero
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD') FROM DUAL;
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;
SELECT TO_DATE('2025-01-01', 'YYYY-MM-DD') FROM DUAL;
SELECT DATE '2025-01-01' FROM DUAL;
PostgreSQL
SELECT TO_CHAR(NOW(), 'YYYY-MM-DD');
SELECT TO_CHAR(NOW(), 'YYYY-MM-DD HH24:MI:SS');
SELECT TO_DATE('2025-01-01', 'YYYY-MM-DD');
SELECT CAST('2025-01-01' AS DATE);