Getdate Function

I will like to use the getdate function
only to receive part of the date:

eg. 2002-11-13.

I cannot use the substring function because it's not valid for datetime datatypes.

Any ideas or suggestions.

Thanks, Vic

Look up CONVERT in books on line.

EG

select convert(varchar(10),getdate(),103)