개발 이야기/DB
SQL 날짜 조건 검색
요령도사
2018. 3. 7. 13:40
반응형
1. select * from [Table Name] where [Date Column] > '2018-03-01' and [Date Column] < '2018-03-02'
2. select * from [Table Name] where [Date Column] between '2018-03-01' and '2018-03-02'
3. CONVERT( varchar(10), [Date Column], 23 ) = '2018-03-01'
23 : Date Format
반응형