Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: tracydirect
- Order by date
-
SQL DateTime Interval
Will this work if the starttime is of the datetime data type or do I have to parse out the time part first? (ie. 2000-01-01 08:00:00)- tracydirect
- Post #3
- Forum: ANSI_SQL
-
SQL DateTime Interval
Each record in my table logs when a process has started (starttime) and finished (endtime). I need to run a query to find out which processes run anytime during the hours of 08:00:00 and 17:00:00. I can' figure out how to do this. Can someone please help. I am using SQL Query analyzer to do...- tracydirect
- Thread
- Replies: 3
- Forum: ANSI_SQL
