selectCONVERT(varchar,getdate(),120)
2004-09-1211:06:08 selectreplace(replace(replace(CONVERT(varchar,120),\'-\',\'\'),\'\',\':\',\'\')
20040912110608 selectCONVERT(varchar(12),111)
2004/09/12 selectCONVERT(varchar(12),112)
20040912 selectCONVERT(varchar(12),102)
2004.09.12 selectCONVERT(varchar(12),101)
09/12/2004 selectCONVERT(varchar(12),103)
12/09/2004 selectCONVERT(varchar(12),104)
12.09.2004 selectCONVERT(varchar(12),105)
12-09-2004 selectCONVERT(varchar(12),106)
12092004 selectCONVERT(varchar(12),107)
0912,2004 selectCONVERT(varchar(12),108)
11:06:08 selectCONVERT(varchar(12),109)
091220041 selectCONVERT(varchar(12),110)
09-12-2004 selectCONVERT(varchar(12),113)
120920041 selectCONVERT(varchar(12),114)
11:06:08.177 selectCONVERT(varchar(10),120)