본문 바로가기

개발/query

mysql 날짜 및 시간 결과 테스트 mysql 날짜 및 시간 결과 테스트 select DATE_FORMAT(now(), '%Y%m%d') -- 20200506 select date_add(curdate(), interval -1 day) -- 2020-05-05 select DATE_FORMAT(date_add(curdate(), interval -1 day), '%Y%m%d') -- 20200505 select DATE_FORMAT(curtime(), '%Y%c%d%H') -- 202050619 select concat(date_format(date_add(curdate(), interval -1 day), '%Y%m%d'), '19') -- 2020050519 더보기
SQL문 연습 SELECT * FROM dbo.F_CODE SELECT SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG FROM dbo.F_FESTIVAL WHERE (FESTIVAL LIKE '고궁축제') SELECT SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG FROM dbo.F_FESTIVAL WHERE (OPEN_MM LIKE '3') AND (SUNJUNG LIKE '1') SELECT SEQ, AREA, SIGU, FESTIVAL, START_DT, END_DT, OPEN_MM, SUNJUNG FROM dbo.F_FESTIVAL WHERE (OPEN_MM LIKE '3') OR (.. 더보기

티스토리툴바