SAMPLE TABLE STRUCTURE
FldDate - Date
FldTime - SmallInt
SAMPLE RECORD
FldDate FldTime
2022-01-02 545
2022-01-15 600
2022-01-25 545
2022-01-01 1545
RESULT TO BE ACHIEVE
FldDate FldTime
2022-01-01 1545
2022-01-02 545
2022-01-15 600
IMAGINATION WRONG CODE
SELECT [FldDate], [FldTime] FROM [Table]
WHERE CONVERT(DATETIME,CONVERT(DATE,[FldDate])+' '+CONVERT(TIME,[FldTime])) >= '2022-01-01 0600'
AND CONVERT(DATETIME,CONVERT(DATE,[FldDate])+' '+CONVERT(TIME,[FldTime])) <= '2022-01-15 0600'
how to combine separate table for date and time for query. thank you.