Link to home
Start Free TrialLog in
Avatar of gogetsome
gogetsomeFlag for United States of America

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)
ASKER CERTIFIED SOLUTION
Avatar of srafi78
srafi78
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gjutras
gjutras

update test
set modifieddate = cast(convert(varchar(10),getdate(),101) as DateTime)