DateTime Convert - MSSQL

[tom123]

Hi

I have to retreive data from a column which has a type of Dattime and is in format 'DD-MM-YYYY HH:MM:SS24h'.

I need to get it in format 'MM-DD-YYYY HH:MM:SS24h'

Thanks in advance

[pcusters]

I have the same problem. Nobody answer

[Roelf]

you can use the convert function to get the data in your desired format:

select convert(char, getdate(), type)

for available types, check the help on "cast and convert"