摘要: USE [DB]GO/****** Object: UserDefinedFunction [dbo].[Func_DateFormat] Script Date: 03/31/2014 18:08:47 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].[Func_DateFormat](@Date datetime, @Format varchar(50))returns varchar(11)asbegin declare @Month varchar(3) declare @Mont... 阅读全文
posted @ 2014-03-31 18:10 Cathy Lee 阅读(273) 评论(0) 推荐(0) 编辑
摘要: Definition and UsageThe CONVERT() function is a general function that converts an expression of one data type to another.The CONVERT() function can be used to display date/time data in different formats.SyntaxCONVERT(data_type(length),expression,style)ValueDescriptiondata_type(length)Specifies the t 阅读全文
posted @ 2014-03-31 17:01 Cathy Lee 阅读(225) 评论(0) 推荐(0) 编辑