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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ThisLad
-
Need help with date related query
Perfect, yes UpdDate is a timestamp, two days pulling out what bit of hair i have left, thanks a million :-) -
Need help with date related query
Hi, I have a query like: SELECT H.DocumentNumber, H.AssignedUser, L.AuthCode FROM AP.DocumentHeader H, AP.DocumentLine L WHERE H.UpdDate > current_date - 2 i.e. I need to return rows where UpdDate within last 2 days but getting error: SQL0401N The data types of the operands for the operation... -
trying to copy data into a spreadsheet
Hi, I'm trying to copy results of a SELECT statement from SQL Advantage into a spreadsheet but it's just pasting each row into a single cell. I know it'll work if I put tabs between the fields but there's over 20,000 rows. Is there any way I can put in tabs with the SELECT statement? Failing...- ThisLad
- Thread
- Replies: 0
- Forum: Sybase: Adaptive (SQL) Server
