ä½ å¯ä»¥ç¨SQL Server 2005(SQLEXPRESSçä¸ç¥éæ没æè¿äºå½æ°)å
ç½®çæ¥æå½æ°ï¼ä¸¾ä¸ªä¾å
使ç¨Datenameå½æ°è¿åæ ¼å¼ä¸º:mm/dd/yyyyï¼ç±»å为å符串
select (Datename("mm",åå)+'/'+Datename("dd",åå)+'/'+Datename("yyyy",åå)) as Date from 表å
温馨提示:答案为网友推荐,仅供参考