gogetsome
asked on
Using getdate() to provide only short date
Hello, how can I use the getdate() function to only provide a short date like 12/31/2007 on an update statement?
I was thinking something like this would work but it is not...
update test
set modifieddate = getdate(convert, 101)
I was thinking something like this would work but it is not...
update test
set modifieddate = getdate(convert, 101)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
set modifieddate = cast(convert(varchar(10),g