Hi,

check it :

select

convert(varchar,convert(datetime,

substring('29/10/2007',charindex('/','29/10/2007')+1,2)+'/'+

left('29/10/2007',charindex('/','29/10/2007')-1)+'/'+

right('29/10/2007',charindex('/',reverse('29/10/2007'))-1)

),101)

Output: 10/29/2007

HI,

U can try in this way:)

select convert(varchar, getdate(), 3) ---19/11/07

select convert(varchar, getdate(), 103)---19/11/2007

thnxm

Arjuna

Orange Business Services(India)

Hi ,

Not sure that the following code will help u or not. If it then u may put it into proc or can use it to update.Given below example as...