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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem Retrieving Interval Data from Previous Days
I know it is the SQL forum, that's why I'm posting the question (as my query is being done in SQL) The database that stores the data that I'm retrieving is Sybase. I've tried the solution you suggested: WHERE (RECORD_TYPE = 'INTERVAL') AND DATE_TIME BETWEEN CONVERT (varchar(8)...- evldzl
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Problem Retrieving Interval Data from Previous Days
I currently have a query that runs daily at night to capture interval data from that day. The syntax I use to capture this data is: WHERE (RECORD_TYPE = 'INTERVAL') AND DATE_TIME BETWEEN CONVERT (varchar(8), GETDATE(),1) + ' 00:00:00' AND CONVERT (varchar(8), GETDATE(),1) + ' 23:59:00'...- evldzl
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
