In MySQL there's the DATE\_FORMAT() function that allows to represent a given date value according to the specified pattern.

Is there something like it in MS SQL Server?

The statement I'm trying to format is:

`SELECT TOP 1 CONVERT(VARCHAR(20), ot.Timestamp,110) AS 'TS' FROM ot, cl WHERE ot.CompID = cl.CompID;`

Which outputs as MM-DD-YYYY. There are other styles, but I haven't found one that suits me.

I need something that outputs as DD/MM/YYYY HH:MM. Where HH is 24 hour format.

How can I best do this?