View Full Version : DateTime Convert - MSSQL

01-11-2008, 01:03 PM

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

12-16-2008, 10:28 AM
I have the same problem. Nobody answer

12-16-2008, 12:13 PM
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"

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum