troubleshooting Question

Return date part only

Avatar of zolf
zolfFlag for United Arab Emirates asked on
DB Reporting ToolsMicrosoft SQL Server 2005
10 Comments1 Solution184 ViewsLast Modified:
hello there,

i am using SSRS and getting my data from mysql using odbc.now my problem is transactions.CheckDate
returns date with time.i just want the date part.please help to display only the date part in my report.

SELECT     transactions.price, transactions.CheckDate, products.image_name AS `Product Name`, products.id
FROM         transactions, ShoppingBasket, ShoppingBasketItems, products
WHERE     transactions.id = ShoppingBasket.TransactionID AND ShoppingBasket.pkID = ShoppingBasketItems.ShoppingBasketID AND
                      ShoppingBasketItems.ProductID = products.id AND (transactions.state = 1)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros