just date part

[Ginka]

I'm comparing dates, but the values stored in the DB contains the time part too.

I just need for example if I use the following code

SELECT GETDATE()
I get
2006-04-19 12:51:01.827

I just need the date

Is there any function o way to get just the date???




Deeply I need to do something like this

SELECT *
FROM MyTable
WHERE Date = @MyDate

@MyDate contains just a date, but when I receive the value it contains the date and time, so it is almost impossible to get coincidences

 

[SQLDenis]

like this

declare @MyDate datetime
select @MyDate = convert(varchar,getdate(),112)
--select @MyDate,dateadd(d,1,@MyDate)
SELECT *
FROM MyTable
WHERE Date >= @MyDate
and Date < dateadd(d,1,@MyDate)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Ginka]

yeah that works, but I thougth would be another way to do that.

Anyway

thanks SQLDenis

 

[SQLDenis]

other ways have a side effect called table scans

for example this is bad code

SELECT *
FROM MyTable
WHERE convert(varchar,Date,112)= convert(varchar,@MyDate,112)


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/