SQL Server Format Date DD.MM.YYYY HH:MM:SS

Viewed 120410

How can I get a date like 'dd.mm.yyyy HH:MM:SS' I tried the following but it's not exactly what I'm looking for...

select convert(varchar(20),getdate(),113)

result: 14 Jul 2011 09:23:57

Thanks a lot Largo

4 Answers
Related