select convert(varchar,getdate(),0):
Apr 9 2014
4:01PM
select convert(varchar,getdate(),1):
04/09/14
select convert(varchar,getdate(),2):
14.04.09
select convert(varchar,getdate(),3):
09/04/14
select convert(varchar,getdate(),4):
09.04.14
select convert(varchar,getdate(),5):
09-04-14
select convert(varchar,getdate(),6):
09 Apr
14
select convert(varchar,getdate(),7):
Apr 09,
14
select convert(varchar,getdate(),8):
16:01:20
select convert(varchar,getdate(),9):
Apr 9 2014
4:01:20:540PM
select convert(varchar,getdate(),10):
04-09-14
select convert(varchar,getdate(),11):
14/04/09
select convert(varchar,getdate(),12):
140409
select convert(varchar,getdate(),13):
14/09/04
select convert(varchar,getdate(),14):
04/14/09
select convert(varchar,getdate(),15):
09/14/04
select convert(varchar,getdate(),16):
Apr 9 2014
16:01:20
select convert(varchar,getdate(),17):
4:01PM
select convert(varchar,getdate(),18):
16:01
select convert(varchar,getdate(),19):
4:01:20:650PM
select convert(varchar,getdate(),20):
16:01:20:656
select convert(varchar,getdate(),21):
14/04/09
16:01:20
select convert(varchar,getdate(),22):
14/04/09
4:01PM
select convert(varchar,getdate(),23):
2014-04-09T16:01:20
select convert(varchar,getdate(),100):
Apr 9 2014
4:01PM
select convert(varchar,getdate(),101):
04/09/2014
select convert(varchar,getdate(),102):
2014.04.09
select convert(varchar,getdate(),103):
09/04/2014
select convert(varchar,getdate(),104):
09.04.2014
select convert(varchar,getdate(),105):
09-04-2014
select convert(varchar,getdate(),106):
09 Apr
2014
select convert(varchar,getdate(),107):
Apr 09,
2014
select convert(varchar,getdate(),108):
16:01:32
select convert(varchar,getdate(),109):
Apr 9 2014
4:01:32:083PM
select convert(varchar,getdate(),110):
04-09-2014
select convert(varchar,getdate(),111):
2014/04/09
select convert(varchar,getdate(),112):
20140409
select convert(varchar,getdate(),113):
2014/09/04
select convert(varchar,getdate(),114):
04/2014/09
select convert(varchar,getdate(),115):
09/2014/04
select convert(varchar,getdate(),116):
Apr 9 2014
16:01:32
select convert(varchar,getdate(),117):
2014/04/09
16:01:32
select convert(varchar,getdate(),118):
2014/04/09
4:01PM
Sysbase: select convert(varchar,getdate(),i)所代表的含义【原创】,布布扣,bubuko.com
Sysbase: select convert(varchar,getdate(),i)所代表的含义【原创】
原文：http://www.cnblogs.com/alexzp/p/3654357.html