how to get just the date?

  • Thread starter Thread starter Smokey Grindle
  • Start date Start date
S

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!
 
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!
Click to expand...

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.
 
actually I posted it to the SQL group *scratches head* not sure how it ended
up here
 
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!
Click to expand...
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
 
Back
Top