I have Table with two smalldatetime columns, where one is startTime and other one is endTime.
I need to select all values from table which between times of both columns compared to getdate()' time.
I'm using SQL-Server 2005.
SELECT value1 FROM tableA WHERE CONVERT(varchar, GETDATE(), 108) BETWEEN CONVERT(varchar, Table_1.StartDate, 108) AND CONVERT(varchar, Table_1.EndDate, 108);
Should do the trick