没有听说过,只能自己写个函数,给你一用户函数用用吧:/* 用途:将时间转换为带中文字符的格式 参数:源时间,是否要求毫秒的标志(0为短时间标志,1为长时间标志) 返回:转换后的时间格式 */ CREATE FUNCTION ConvertDateToChs(@sourceDate datetime,@Flag_Short bit) RETURNS VARCHAR(40) AS BEGIN DECLARE @STRING VARCHAR(40) IF @Flag_ShorT = 0 SET @STRING = (CAST(YEAR(@sourceDate) AS VARCHAR(4))+'年'+CAST(MONTH(@sourceDate) AS VARCHAR(2))+'月'+CAST(DAY(@sourceDate) AS VARCHAR(2))+'日') ELSE SET @STRING = (CAST(YEAR(@sourceDate) AS VARCHAR(4))+'年'+CAST(MONTH(@sourceDate) AS VARCHAR(2))+'月'+CAST(DAY(@sourceDate) AS VARCHAR(2))+'日 '+CONVERT(VARCHAR,@sourceDate,8)) RETURN @STRING END
用途:将时间转换为带中文字符的格式
参数:源时间,是否要求毫秒的标志(0为短时间标志,1为长时间标志)
返回:转换后的时间格式
*/
CREATE FUNCTION ConvertDateToChs(@sourceDate datetime,@Flag_Short bit)
RETURNS VARCHAR(40) AS
BEGIN
DECLARE @STRING VARCHAR(40)
IF @Flag_ShorT = 0
SET @STRING = (CAST(YEAR(@sourceDate) AS VARCHAR(4))+'年'+CAST(MONTH(@sourceDate) AS VARCHAR(2))+'月'+CAST(DAY(@sourceDate) AS VARCHAR(2))+'日')
ELSE
SET @STRING = (CAST(YEAR(@sourceDate) AS VARCHAR(4))+'年'+CAST(MONTH(@sourceDate) AS VARCHAR(2))+'月'+CAST(DAY(@sourceDate) AS VARCHAR(2))+'日 '+CONVERT(VARCHAR,@sourceDate,8))
RETURN @STRING
END