I'm new to SQL Server 2000 and have a question about DateTime. I'm more comfortable with Access and how it handles dates. I use a # for dates there. Also I never had the actual time in the field either. Now I have a table in SQL Server with date and time. I try to run a query with just date but it doesn't work. How can I convert this field to just date, or what function can I use in my query to just look at the date and ignore the time? Thanks.

Hello RickP,

I suggest first you run following small script in query analyzer and see the result. Then look up help On function CONVERT. Also read topic 'Truncating the time from a datetime field' on page 372 of the book and you will not have any problem with datetime field in sql Server 2000 again.

Hope this helps.
tbj

declare @todaysDate DateTime
declare @ConvertedDate datetime
declare @aDate datetime

set @aDate = '12/05/2005'
set @todaysdate = getdate()
set @converteddate = convert( datetime, convert(varchar(12), @todaysdate, 111))

print 'getdate = ' + cast(getdate() as varchar)
print ' todays date = ' + convert(varchar(12), @todaysdate, 111)
print 'Converted date = ' + convert(varchar(12), @converteddate, 111)
print 'aDate = ' + convert(varchar(12), @aDate, 111)

print ' (varchar-10) todays date = ' + convert(varchar(10), @todaysdate, 111)
print ' (varchar-10) Converted date = ' + convert(varchar(10), @converteddate, 111)

go