...

View Full Version : DateTime Convert - MSSQL



tom123
01-11-2008, 02:03 PM
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
12-16-2008, 11:28 AM
I have the same problem. Nobody answer

Roelf
12-16-2008, 01: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