how to get just the date?

[Smokey Grindle]

this is one thing that has always annyoed me in SQL is the lack of ability
to get just the date of a datetime field... with SQL Server 2005 is there
any easy and fast way to compare a date against another date excluding the
time? thanks!

 

[zacks]

this is one thing that has always annyoed me in SQL is the lack of ability
to get just the date of a datetime field... with SQL Server 2005 is there
any easy and fast way to compare a date against another date excluding the
time? thanks!

This is really a question for the SQL Server group, but here is how I
isolate the date part of a SQL Datatime column:

left(convert(varchar, datetimecolumnname, 120), 10)

This is a SQL command, NOT a VB.NET command!!!

This results in a date value in the format: YYYY-MM-DD.

 

[Daniel Bass]

This is one for SQL group, but I'm not sure what you mean...

In SQL Server 2000 you can do a DateDiff on any element, so if you want to
calculate the number of days from one day to the next you can simply do this
with the DateDiff function.

http://msdn2.microsoft.com/en-us/library/aa258269(sql.80).aspx

 

[Smokey Grindle]

actually I posted it to the SQL group *scratches head* not sure how it ended
up here

 

[Rad [Visual C# MVP]]

this is one thing that has always annyoed me in SQL is the lack of ability
to get just the date of a datetime field... with SQL Server 2005 is there
any easy and fast way to compare a date against another date excluding the
time? thanks!

What you need is the convert function. You can pass as a parameter one
of the formats that give you date only. Details are in SQL Server
books online