제가 input 박스에 시간,분을 적어서 오후 2시 40분이라면 1440으로 적어 시간을 조회하고싶습니다
2022-07-14 14:54:52.620
2022-07-14 14:54:52.620
2022-07-14 14:54:52.620
2022-07-14 14:54:52.620
2022-07-14 14:54:52.633
2022-07-14 14:54:52.633
2022-07-14 14:54:52.603
2022-07-14 14:54:52.603
컬럼의 결과는 이거인데 이거를 조회할수있는 조건문을 where 절에 넣고싶어서 그런데 like문 밖에없을까요?
WITH T AS ( SELECT CONVERT(DATETIME ,'2022-07-15 14:10:11') TM UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 14:20:12') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 14:30:13') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 14:40:14') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 14:50:15') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 15:00:16') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 15:10:17') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 15:20:18') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 15:30:19') UNION ALL SELECT CONVERT(DATETIME ,'2022-07-15 15:40:10') ) SELECT * FROM T WHERE TM BETWEEN CONVERT(DATETIME , '2022-07-15 ' + SUBSTRING('1440',1,2) + ':' + SUBSTRING('1440',3,2) + ':' + '00' ) AND CONVERT(DATETIME , '2022-07-15 ' + SUBSTRING('1440',1,2) + ':' + SUBSTRING('1440',3,2) + ':' + '59' )