1) 1999-05-27-00.00.00.000000 <== The date format supplied
2) 1999-05-27 00:00:00.000 <== The date format i want to convert to


Is there a way to convert from 1 to 2?

------------------------------------------------------------------
edit --------------------------------------------------------------
------------------------------------------------------------------

The original question probably wasnt specific enough. (1) comes from a datetime field that is queried in a database. However, i need to select the dates with the format of (2)

please help