Larry Brister
asked on
Format date as MMDDYYYY
I need to always return the date as 8 characters
so 8/27/2011
would be
09272011
so 8/27/2011
would be
09272011
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
another option:
select REPLACE( CONVERT(varchar(10),getdat e(),101), '/', '' )
select REPLACE( CONVERT(varchar(10),getdat
ASKER
Thanks
so
select right(convert(varchar,getd
give MMDDYYY