Convert a String into datetime

[NET India]

Hello Friends, I've a date in string variable i want to convert this string into datetime format(mm/dd/yyyy) but it's giving me an error. Because my date is stored in dd/mm/yyyy but sql analyser require datetime in mm/dd/yyyy. So please suggest me the way. Here is my example Declare @str varchar(100),@strDate datetime Set @str='14/02/2010'--(dd/mm/yyyy) Set @strDate=@str Print @strDate

[Mycroft Holmes]

Use the following

Declare @str varchar(100),@strDate datetime
Set @str='14/02/2010'--(dd/mm/yyyy)
Set @strDate=CONVERT(DATETIME, @str,103)
Print @strDate

Look into CONVERT in BOL

Never underestimate the power of human stupidity RAH

[Niladri_Biswas]

Try this

Declare @str varchar(100)
Set @str='14/02/2010'--(dd/mm/yyyy)
select ConvertedDate = CONVERT(varchar(10),CONVERT(datetime,@str,103),101)--mm/dd/yyyy

Output:

ConvertedDate
02/14/2010

:)

Niladri Biswas

[Karan_TN]

try the below

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]