Sysbase: select convert(varchar,getdate(),i)所代表的含义【原创】

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