T-SQL date format
Posted on 2012-08-10
I have a table where I select customer purchase activity and it will display the date of purchase (along with the time) in ColumnA, in this format:
I want to display the date only, so I added a LEFT function like so:
This will get rid of the time but now the date is displayed I will get:
Aug 06 2012
I want to display it in numeric format but as MM/DD/YYYY so it will look like:
Any ideas how I can do this in T-SQL? Thanks for any assistance.