摘要:
(1)日期转换1. Select CONVERT(varchar(100), GETDATE(), 0) //01 17 2011 8:46AM2. Select CONVERT(varchar(100), GETDATE(), 1) //01 17 2011 8:46AM3. Select CONVERT(varchar(100), GETDATE(), 2) //11.01.174. Select CONVERT(varchar(100), GETDATE(), 3) //17/01/115. Select CONVERT(varchar(100), GETDATE 阅读全文