Getdate Function

[FontanaS]

I want to use the getdate function but it returns the time also.

How do i assign a variable (@CutOffDate) the current system date only and in the format mm/dd/yyyy ?


thanks

 

[rajeevnandanmishra]

use this

select @cutoffdate=convert(char(10),getdate(),101)

 

[mojorourke]

try this in the query analyzer:

declare @CutOffDate varchar(10)

set @CutOffDate= convert(varchar,getdate(),101)
select @CutOffDate