본문 바로가기

Database/Mssql

mysql 날짜조건검색 쿼리 예

mysql 날짜조건검색 쿼리 예

select count(*) from 테이블명 where convert(char(10),create_date,102) > '2009.09.24' and convert(char(10),create_date,102) < '2009.10.22'

select * from 테이블명 where convert(char(10),create_date,102) > '2009.09.24' and convert(char(10),create_date,102) < '2009.10.22'