ASP.NET

EmailSubject.Accepted.ToString()

in D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayatWork.Public.UI\RetroMembersV1WSDLSOAP_HTTP_Service.vb:line 48

SELECT CONVERT(VARCHAR, columnName, 103) AS MyDate From MyTable; 

suriyakaqnnan wrote:

i want to convert the varchar dataype to datetime format

suriyakaqnnan wrote:

f the user enter like 22.3.2004 error msg has to display

CREATE FUNCTION ChangeDateFormat
(
	@STRING NVARCHAR(40),
	@DELIMITER NVARCHAR(40)
)
RETURNS DateTime
AS
BEGIN
	DECLARE @MM as varchar(5)
	DECLARE @DD as varchar(5)
	DECLARE @YY as varchar(5)
	DECLARE @POS INT
	DECLARE @NEXTPOS INT
	DECLARE @INT INT
	DECLARE @TEMP as varchar(50) 
	SET @STRING = @STRING + @DELIMITER
	SET @POS = charindex(@Delimiter,@String)
	SET @INT = 1
	
	WHILE (@POS <> 0)
	BEGIN
		if @INT = 1 
			Begin
				SET @DD = substring(@String,1,@Pos - 1)
			End
		if @INT = 2 
			Begin
				SET  @MM = substring(@String,1,@Pos - 1)	
			End
		if @INT = 3 
			Begin
				SET @YY = substring(@String,1,@Pos - 1)	
			End	
		
		SET @STRING = substring(@String,@pos+1,len(@String))
		SET @POS = charindex(@Delimiter,@String)
		SET @INT = @int + 1
	END 
	SET @TEMP = @MM+'/'+ @DD + '/' + @YY
	
	Return  convert(datetime, @TEMP)
END