I am trying to adjust an SQL query to output in a specific Datetime format. I am close but it needs to output in British Format: dd/mm/yyyy HH:MM:SS.
I have it except there are spaces where the "/" are. I need the / displayed in the output
Here is the code I am using
When vSF.ModifiedDate is Null then '""'
Else ('"' + ltrim(convert(char(20), vSF.ModifiedDate,13)) + '"')
So I imagine I have to combine it with a formatting string of some sort?
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.