Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
15571 Points
2700 Posts
Oct 20, 2010 08:29 PM|LINK
You mean like this?:
CONVERT(VARCHAR,RegistrationDate,100)
http://msdn.microsoft.com/en-us/library/ms187928.aspx
TabAlleman
All-Star
15571 Points
2700 Posts
Re: how to convert date type in SQL query output ?
Oct 20, 2010 08:29 PM|LINK
You mean like this?:
CONVERT(VARCHAR,RegistrationDate,100)
http://msdn.microsoft.com/en-us/library/ms187928.aspx