Datetime

[JChanana]

Is there a way I can query on just the date or just time element in the datetime datatype? I didn't see an option using datepart. Must I use the convert? Is there another option like truncating the time or date out?

 

[tlbroadbent]

You can use CONVERT to display and search dates and times in a variety of formats. I suppose you could try other functions or even create your own in SQL 2000 but CONVERT is easy to use and very powerful. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln