The DATETIME data type does not have format but it is rather stored as
binary value. Formatting is normally best done on the client side.
In T-SQL you can use the CONVERT function with style 109 and a bunch of
string manipulations to get the time formatted as string:
SELECT RIGHT('0' +
LTRIM(STUFF(RIGHT(
CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109)
, 14),
9, 4, ' ')),
11);
--
Plamen Ratchev
http://www.SQLStudio.com