vbnetcoder
asked on
t-sql
How do I format a date to look like this?
Use CONVERT() and the appropriate date and time style.
Like what? Despite popular opinion in my company my mind reading and Jedi mind skills are not all that hot, so you'll have to provide us enough details to answer your question.
In addition to ste5an's Microsoft links EE expert PortletPaul wrote an article called SQL Server Date Styles (formats) using CONVERT() that is an outstanding reference.
In addition to ste5an's Microsoft links EE expert PortletPaul wrote an article called SQL Server Date Styles (formats) using CONVERT() that is an outstanding reference.
SELECT NULL as DateColumnName
ASKER
So sorry! like this: CCYYMMDD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Solves the given problem.