Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-14 : 08:14:09
|
| Vic writes "HelloI need to have a query search for records that are time stamped 30 minutes earlier than the current system time.here is the query I am usingSELECT item_id,item_desc,sum(print_quantity) as qtyFROM dbo.pathguide_pick_ticket_viewWHERE (print_date >= GETDATE() - 1) AND (location_id = 100004) AND (last_maintained_by = 'amazon_picks') OR (last_maintained_by = 'ecomm_picks')group by item_id ,item_descorder by item_id ascI am using this query in a VB6 program the will print a report of things printed in the last 30 min.Ideally I would like to pass a variable to set the time to diffrent intervals. I just need to know how to parse the date outthanksVic" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Searching for time 