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
Printable View
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)