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?