Syntax for CAST:
CAST ( expression AS data_type [ (length ) ])
Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
-----------------------------------------------------------------
select convert(varchar(50),getdate(),112)
-----------------------------------------------------------------
out:20081127
sql 获取时间函数 convert
最新推荐文章于 2023-09-05 16:17:30 发布