Strip time from datetime value

[dibbo]

I'm writing a query that pulls back various values, with one being a datetime value i.e. 2005-04-08 07:29:26.000 (dbo.tblScans.Scan_DateTime)

How do I strip the date off just to leave the time?

been looking at the convert function but can't get the correct syntax..

TIA

 

[hmckillop]

select convert(varchar, tblScans.Scan_DateTime, 101)
from tblScans

"I'm living so far beyond my income that we may almost be said to be living apart

 

[r937]

dateadd(d,datediff(d,0,yourdate),0)

see thread183-972119



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[SQLBill]

dibbo,

Here's two FAQs that might come in handy for you:

FAQ183-5834
FAQ183-5842

-SQLBill

Posting advice: FAQ481-4875

 

[dibbo]

Thanks for the assistance guys...